Project

General

Profile

Actions

Bug #24867

closed

Wokspace update fails because of 'Array' in SQL query

Added by aeun no-lastname-given over 13 years ago. Updated over 13 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
-
Target version:
-
Start date:
2011-01-28
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.5
PHP Version:
5.2
Tags:
Complexity:
Is Regression:
Sprint Focus:

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)

Actions #1

Updated by Ernesto Baschny over 13 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?

Actions #2

Updated by aeun no-lastname-given over 13 years ago

Yes, no custom workspaces were created.

Actions #3

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.

Actions #4

Updated by Ernesto Baschny over 13 years ago

Thanks for the feedback, so I close this issue!

Actions

Also available in: Atom PDF