vb3->vb3: 2. module - error

[may]

Hi,

a small problem, hope so:

The first module went well, the second stops with this message:

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /xyz/www.xyz/subdir_abcd.net/forums/impex/db_mysql.php on line 220

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT * FROM user ORDER BY userid LIMIT 0,25
mysql error:

mysql error number: 0

Date: Wednesday 28th of July 2004 11:16:09 PM
Script: http://www.abcd.net/forums/impex/index.php //also changed
Referer: http://www.abcd.net/forums/impex/index.php //also changed
Username: admin
IP Address: xxx.xxx.xxx.xx

Both forums are V3.0.3, they were fresh updated before importing. I'd also a look at:
Import error - http://www.vbulletin.com/forum/showthread.php?t=101784&highlight=import%2A+module
Error when associating users - http://www.vbulletin.com/forum/showthread.php?t=101653
Bug tracker, associate_user - http://www.vbulletin.com/forum/bugs.php?do=view&bugid=2719

Thanks and regards,
may

[Steve Machol]

Usually a 'mysql error number: 0' means that the server encountered an unknown problem with the database. I suggest repairing both dbs. Once you've done this, run this query:

DELETE FROM datastore WHERE title='ImpExSession';

Then try the import again.

[may]

Hi Steve,

okay, I've made this:


un-install vBindex (sorry, I didn't say that before)
optimize and repair of source db so far till there were only OKs
fresh dump of it and upload to the target forum
opimize and repair of target db - everything ok
new import of source db in a fresh database
your query:
gelöschte Zeilen:*1 (die Abfrage dauerte 0.0005 sek)
SQL-Befehl*: DELETE FROM datastore WHERE title = 'ImpExSession'
new impex-import and...


...saw many OKs but also the message:

Please set 'sourceexists = true' in ImpExConfig.php

After this done and a new DELETE FROM datastore WHERE title = 'ImpExSession' now again a new impex-import with a new message (beneath everything else okay):

archive NOT found or a non standard table.

How much attention should we give this message or can I go to the next step with associating users?

may

[Steve Machol]

There is no archive table in vB. Therefore I don't see how this error could be generated from a vB-to-vB import. Did you have any hacks installed to either database?

[may]

That's right Steve, I can see no archiv table in the target db, but there is a subforum called so in the source db. No, there has been no more hack than vBindex and for this I used the builtin routine to get rid of it, but it seems with no success. A vbindex_shoutbox table resists after the un-install process - that's not fine winters!

may

[Steve Machol]

Well the error is calling this a 'table'. Sorry but I have no idea what this error means.

[Zachery]

That error will cause no problems, its just saying impex found somthing it wasnt expecting, you can continue without worry.

[may]

Okay, then I will go ahead and try the next step.

By the way, I've mentioned, that my target db has 85 and the source db 89 tables!

Will tell soon...

Thanks, may

[may]

...so for today I will have a rest:

Database error in vBulletin:ImpEx Target 3.0.3:

Invalid SQL:
INSERT INTO usergroup
(
importusergroupid, title, description,
usertitle, passwordexpires, passwordhistory,
pmquota, pmsendmax, pmforwardmax,
opentag, closetag, canoverride,
ispublicgroup, forumpermissions, pmpermissions,
calendarpermissions, wolpermissions, adminpermissions,
genericpermissions, genericoptions, attachlimit,
avatarmaxwidth, avatarmaxheight, avatarmaxsize,
profilepicmaxwidth, profilepicmaxheight, profilepicmaxsize
)
VALUES
(
'1',
'Unregistered / Not Logged In',
'',
'Guest',
'0',
'0',
'0',
'0',
'',
'',
'',
'0',
'0',
'11',
'0',
'17',
'0',
'0',
'64',
'8',
'0',
'80',
'80',
'5000',
'100',
'100',
'100000'
)

mysql error: Unknown column 'pmforwardmax' in 'field list'

mysql error number: 1054

Date: Thursday 29th of July 2004 02:02:43 AM
Script: http://www.abcd.net./forums/impex/index.php
Referer: http://www.abcd.net/forums/impex/index.php
Username: admin
IP Address: xxx.xxx.xxx.xx

A longer time ago I changed from ubb to phpBB and then to vB2xx. May be there happend something unexpected now?

may

[Scott MacVicar]

Were you running 3.0.3 prior to running the impex module?

pmforwardmax was added during vB2 -> vB3 upgrade or the vB3 install.

[may]

Hi Scott, V3.0.3 has been fresh upgraded and under that version no posts have been made or something else.

So I've compared the two dbs and the source has 4 tables more than expected: archive, hitcount, hottopics, perpage and to my surprise, both dbs have one table the other doesn't have: source with vbindex_shoutbox and the target db with vbfields.
(a) How many tables should a vb3 db have and (b) can I delete the described tables?

Regards, may


---
Correction: a) I can see in ACP Importing & Maintenance

[may]

Okay that all looks a bit difficult and would like to ask for a solution at this point, with which it could be lived:

- Can I delete the tables: archive, hitcount, hottopics and vbindex_shoutbox without negative consequenzes for vB?

- Can I ignore above error messages and go on using my target db without errors?

Thanks and regards,
may

[Austin Dea]

What you should have done was uninstall any hacks on your vB2 forums before attempting to upgrade to vB3.

[may]

Thanks for your help Austin!

@all, so what could be to do?


How many tables should a vb3 db have?
Can I delete the described tables like archive, hitcount, hottopics, perpage and especially vbfields?
Could it be possible for a "normal" user by comparing two different (one of them clean and fresh installed) dbs to get wrong entries away?
Scott said: "pmforwardmax was added during vB2 -> vB3 upgrade or the vB3 install" - Is it possible to get rid of such old entries to achieve a fully functional db?


To point 1: I think 84, point 2: I'm short before doing it 3: If this could promise success I would do it.

Regards, may


---
Addition I: 1. there are 84 create tables in install script, so it has to be 84 tables in db. 2. For this reason I've deleted above described tables. 3. Unresolved 4. Unresolved

Addition II: To point 2 I've seen an answer here (http://www.vbulletin.com/forum/showpost.php?p=711726&postcount=2) and it looks so:
DELETE FROM datastore WHERE title = 'ImpExData'

DROP TABLE vbfields
Important for me that missing DROP TABLE and now I know why there has been vbfields! It comes from ImpEx itself. Nevertheless, 3. Unresolved 4. Unresolved

Addition III: To point/question 3, I found something about search term "compare AND table*" and it looks like that what I suggest, here - database changes (http://www.vbulletin.com/forum/showthread.php?t=72822&highlight=compare+table%2A), especially Wayne's post (http://www.vbulletin.com/forum/showpost.php?p=463176&postcount=5):
You will find the default database structure in the install.php file that comes with vBulletin 2.3.0.

You could use it to create a database, then compare the structure of your database and the default one using Beyond Compare if you don't want to wait for the script. 3. Without having a script, unresolved 4. Unresolved


Addition IV: "Beyond Compare" only runs with Windows, I need something for MAC and have found (BBEdit Lite cannot compare textfiles) Textwrangler from Bare Bones Software Inc. (http://www.barebones.com/index.shtml). It looks very difficult to do it that way. So: 3. Without having a script, unresolved 4. Unresolved

[may]

Any ideas?

[may]

Hello, may I ask you if there is something in progress?

Or should I start a new thread to collect some ideas about importing and old databases? Out of my view it could solve at least one of above points 3 and 4. What do you think about it?

Regards, may

[Steve Machol]

Can you restate your questions? I really don't understand what you are asking.

[may]

Three month later - Thanks Steve for your question.


So, today I've got it by my own - yes! :)


After searching in bulletin software from other factories, there I'could not found any importer, who would stay as a step between to exclude my described problem above. No way.

Here it goes: I've made a fresh install of vB303 and imported one after another the two vBs, but at this time under knowledge of this (http://www.vbulletin.com/forum/showthread.php?t=111724) thread.

I'll never forget 'vbfields' and its sessions ;)

Thanks to all, may

[Steve Machol]

Sorry, but I still don't understand what you are asking.