Search found 2 matches

by fedetamayo
Mon Feb 12, 2007 9:47 pm
Forum: [2.0.x] Convertors
Topic: Converter Release: Snitz Forums to PHPBB and PHPNuke
Replies: 83
Views: 59384

Snitz to phpbb converter

No luck.

-----------------------------------------------

Error

SQL-query :

UPDATE `FORUM_TOPICS` SET `LASTACTIVITY` = CAST( T_LAST_POST AS DATETIME )

MySQL said:


You have an error in your SQL syntax near '( T_LAST_POST AS DATETIME ) ' at line 1
by fedetamayo
Fri Feb 09, 2007 11:52 pm
Forum: [2.0.x] Convertors
Topic: Converter Release: Snitz Forums to PHPBB and PHPNuke
Replies: 83
Views: 59384

Couldn't convert last activity from free text to DATETIME in

Hi Endeavour2, I'm using your converter. All fine until step 4, I get the following error: MySQL query error! Query was: UPDATE `FORUM_TOPICS` SET `LASTACTIVITY` = CAST(T_LAST_POST AS DATETIME) mysql_errno = 1064 mysql_error = You have an error in your SQL syntax near '(T_LAST_POST AS DATETIME)' at ...

Go to advanced search