PDA

View Full Version : mysql error!!!


Aeolian
Fri 23rd Apr '04, 10:05pm
Database error in vBulletin:ImpEx Target 3.0.1:

Invalid SQL:
INSERT INTO thread
(
forumid, title, importforumid,
importthreadid, firstpostid, lastpost,
pollid, open, replycount,
postusername, postuserid, lastposter,
dateline, views, iconid,
notes, visible, sticky,
votenum, votetotal, attach, similar
)
VALUES
(
'9',
'what is the prog rock situation in BD??',
'2',
'2005',
'',
'fulbanu's_revenge',
'',
'1',
'10',
'',
'671',
'',
'1050384917',
'94',
'',
'',
'1',
'0',
'',
'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_revenge',
'',
'1',
'10',
'',
'6

mysql error number: 1064

Date: Saturday 24th of April 2004 12:50:22 AM
Script: http://www.domain.com/vbulletin/impex/index.php
Referer:
Username: nick
IP Address: x.x.x.x


i understood the problem, mysql unable to convert the ' (apostrophe) in any nick. I edited 1 nick and it worked fine; now i can't go around and edit all nicks. so what change do i have to make in order to make it work.

mysql (4.0.18-standard)
php 4.3.4

thanx..
Zachery
Sat 24th Apr '04, 12:05am
What importer were you running?
eva2000
Sat 24th Apr '04, 1:42am
post your phpinfo.php url as well
Steve Machol
Sat 24th Apr '04, 1:47am
<moved to correct forum>
Aeolian
Sat 24th Apr '04, 3:23am
sorry for posting in wrong section..
i am running ImpEx Importer version 1.2

phpinfo url: url

thanx..
Zachery
Sat 24th Apr '04, 5:03am
What are you importing from?
Jerry
Sat 24th Apr '04, 6:25am
I've corrected the ImpExDatabase::import_thread() function to deal with this and updated the impex download. Please download it and try again.
Aeolian
Sat 24th Apr '04, 2:06pm
i was importing from IPB 1.3
anyway it works now..

but attachment/signature/avatar were not imported..
and PMs were imported with the LOG (ipb) msgs.

previously i imported from IPB with the importer created by http://www.vbulletin-germany.com/ and i was 98% successful.
so i believe more work is needed on the official importer.. as it was hardly 75% efficient.

thank you..
Jerry
Sun 25th Apr '04, 12:43pm
i was importing from IPB 1.3
anyway it works now..

but attachment/signature/avatar were not imported..
and PMs were imported with the LOG (ipb) msgs.

previously i imported from IPB with the importer created by http://www.vbulletin-germany.com/ and i was 98% successful.
so i believe more work is needed on the official importer.. as it was hardly 75% efficient.

thank you..

They are the same scripts, germany links to our download, possiably you got a newer build of impex, its gets updated most days at the moment.