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
Search found 2 matches
- 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
- 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 ...