vblogetin to vblog

[Sychev_S]

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'

[Paul M]

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:

[Lizard King]

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-goekceimam/impex-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


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:

[Jerry]

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.

[Lizard King]

Sure , do you want me to continue posting them on this issue or create a new issue for each of them ?

[Lizard King]

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

[Jerry]

I'll test all the issues I've found and fixed tomorrow, then release 1.85.