vblogetin to vblog Issue Tools
issueid=23091 Sun 2nd Sep '07 9:17am
Senior Member
vblogetin to vblog
mysql error when importing
I get this error when trying to import data from vblogetin beta 3 to vblog on step 1 (check and update database).

blog - importblogid Completed
blog_attachment - importblogattachmentid Completed
blog_category - importblogcategoryid Completed
blog_moderator - importblogmoderatorid Completed
blog_rate - importblograteid Completed



There seems to have been a problem with the database.

ImpEx Database errormysql error: Invalid SQL: DESCRIBE blog_subscribepost importblogsubscribepostid
mysql error: Table 'talkint_****.blog_subscribepost' doesn't exist
mysql error number: 1146
Date: Sunday 02nd 2007f September 2007 08:15:41 AM
Database: talkint_****
MySQL error: Access denied for user 'talkint_admin'@'localhost' to database 'talkint_****2'
Issue Details
Issue Type Bug
Project ImpEx
Category SQL error
Status Fixed (Closed)
Priority 2
Affected Version 1.84
Fixed Version 1.85
Users able to reproduce bug 2
Users unable to reproduce bug 0
Attachments 0
Assigned Users Jerry
Tags (none)

Mon 3rd Sep '07 8:31pm
vB.org Team
  
Confirmed here.

I have also come to report this bug.

Altering tables
ImpEx will now Alter the tables in the vB database to include import id numbers.This is needed during the import process for maintaining refrences between the tables during an import.If you have large tables (i.e. lots of posts) this can take some time.They will also be left after the import if you need to link back to the origional vB userid.
blog - importblogid Completed
blog_attachment - importblogattachmentid Completed
blog_category - importblogcategoryid Completed
blog_moderator - importblogmoderatorid Completed
blog_rate - importblograteid Completed


ImpEx Database errormysql error: Invalid SQL: DESCRIBE vb3_blog_subscribepost importblogsubscribepostid

mysql error: Table 'xxxxxx_forum.vb3_blog_subscribepost' doesn't exist

mysql error number: 1146

Date: Monday 03rd of September 2007 07:20:16 PM
Database: xxxxxx_forum
MySQL error:
Reply
Mon 3rd Sep '07 8:46pm
Senior Member
  
This is the only beginning bug. Impex currently has lots of problems. I managed to fix most of them but in the end i was really fed up. You can read the fixes here http://www.vbseo.com/blogs/mert-goek...-nightmare-10/

Maybe you can continue from where i stock Paul. The last error i receive was on the step 3 where impex shall associate users. The error is

Code:
ImpEx Database errormysql error: Invalid SQL:
INSERT INTO blog_user
(
bloguserid, importbloguserid, title, description, options,
viewoption, comments, lastblog, lastblogid,
lastblogtitle, lastcomment, lastcommenter, lastblogtextid,
allowsmilie, subscribeown, subscribeothers,
moderation, deleted, draft, options_everyone,
options_buddy, options_ignore, ratingnum, ratingtotal,
rating, pending
)
VALUES
(
'0',
'7',
'title',
'description',
'0',
'all',
'0',
'0',
'0',
'',
'0',
'',
'0',
'1',
'none',
'none',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0'
)


mysql error: Duplicate entry '0' for key 1

mysql error number: 1062

Date: Monday 03rd 2007f September 2007 05:20:55 AM
Database: ***
MySQL error:
Reply
Mon 3rd Sep '07 8:58pm
ImpEx Developer
  
Each of these three are different issues, I'll deal with them separately, as for listing the bugs, the tracker here is the best place for them.
Reply
Mon 3rd Sep '07 8:59pm
Senior Member
  
Sure , do you want me to continue posting them on this issue or create a new issue for each of them ?
Reply
Mon 3rd Sep '07 11:16pm
Senior Member
  
Fix :

Find all instances of subscribepost inside the following files and replace them with subscribeentry

ImpExModule.php line 101
impex_language.php line 491
vbfields.php line 598 - 600 - 601 - 602 - 603 - 604
Reply
Mon 3rd Sep '07 11:23pm
ImpEx Developer
  
I'll test all the issues I've found and fixed tomorrow, then release 1.85.
Reply
Reply