i am running import from vb3.8 to vb4.2, first of all i got this error while running import attachment module.
ImpEx Database error
And secondly i can't see the thread content of many imported threads, when i open the threads the threads are empty and the urls look like this
as you can see page = 0 and #post0
and the last i also noticed that many of the imported users are not showing their profiles, as i hover on any username it shows the url as
please help me in fixing this, i already tried to run all general update tools.
Thanks in advance
- - - Updated - - -
i figure out the mysql error, and successfully imported the attachments, need help with the rest.
ImpEx Database error
Code:
mysql error: Invalid SQL: INSERT INTO vbjake_attachment ( importattachmentid, filename, userid, dateline, counter, reportthreadid, caption, state, contentid, filedataid, contenttypeid, settings, displayorder ) VALUES ( '229', 'rca record label logo & rangy mountain\'s rmc logo.JPG', '3811', '1230052922', '15', 0, 'rca record label logo & rangy mountain's rmc logo.JPG', 'visible', 14265, 2335, 1, '', 0 ) mysql error: 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 's rmc logo.JPG', 'visible', 14265, 2335, 1, '', 0 )' at line 25 mysql error number: 1064 Date: Thursday 08th 2012f November 2012 07:54:50 AM Database: dbname MySQL error:
as you can see page = 0 and #post0
and the last i also noticed that many of the imported users are not showing their profiles, as i hover on any username it shows the url as
please help me in fixing this, i already tried to run all general update tools.
Thanks in advance
- - - Updated - - -
i figure out the mysql error, and successfully imported the attachments, need help with the rest.
Comment