Bug #24867
closedWokspace update fails because of 'Array' in SQL query
0%
Description
When upgrading from T3 4.4.6 to 4.5 LTS I try to update the workspaces. When I start the step I get an SQL error. With the show queries option it's like this:
Step 3 - Perform updates
Versioning and Workspaces
Update successful!
SELECT COUNT FROM sys_workspace WHERE adminusers != "" AND adminusers NOT LIKE "%be_users%" AND adminusers NOT LIKE "%be_groups%" AND deleted=0
SELECT COUNT FROM pages WHERE t3ver_wsid=-1
SELECT COUNT FROM tt_content WHERE t3ver_wsid=-1
SELECT COUNT FROM pages_language_overlay WHERE t3ver_wsid=-1
SELECT COUNT FROM sys_template WHERE t3ver_wsid=-1
SELECT COUNT FROM backend_layout WHERE t3ver_wsid=-1
SELECT COUNT FROM tx_templavoila_tmplobj WHERE t3ver_wsid=-1
SELECT COUNT FROM tx_templavoila_datastructure WHERE t3ver_wsid=-1
SELECT COUNT FROM tt_news WHERE t3ver_wsid=-1
SELECT COUNT FROM tx_dam WHERE t3ver_wsid=-1
SELECT COUNT FROM tx_dam_cat WHERE t3ver_wsid=-1
SELECT * FROM sys_workspace WHERE deleted=0
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Array' at line 1
I cannot guess which query would have been the next with the error.
Also it's not correct to say it was successfull even if there was an SQL error.
Ask me if you need more infos.
(issue imported from #M17375)
Updated by Ernesto Baschny almost 14 years ago
From the above log, it seems that you didn't have any custom workspace in your database before (no records in sys_workspace), is that right?
Updated by aeun no-lastname-given almost 14 years ago
Yes, no custom workspaces were created.
Updated by aeun no-lastname-given over 13 years ago
For your notice: I tried to continue the upgrade of said project with T3 4.5.2 src package. Now it was upgrading fine and everything works again.
Updated by Ernesto Baschny over 13 years ago
Thanks for the feedback, so I close this issue!