Trying to import agora forum into vB - fails

[misaochankun]

Error:
-------
Database error in vBulletin:ImpEx Source 3.0.6:

Invalid SQL:
SELECT cle, userid
FROM clientservicesmidwestregion_users
ORDER BY cle
LIMIT 0,25
mysql error: Unknown column 'cle' in 'field list'

mysql error number: 1054

Date: Monday 09th of May 2005 04:16:30 PM

Config file:
----------
[ Target Database ]
; The following settings allow ImpEx to connect to the vBulletin 3
; database into which you will be importing data.

targetdatabasetype = mysql
targetserver = localhost
targetuser = ""
targetpassword = ""
targetdatabase = vbulletin
targettableprefix =

[ Source Database ]
; If the system that is being imported from uses a database,
; enter the details for it here and set 'sourceexists' to TRUE.
; If the source data is NOT stored in a database, set 'sourceexists' to FALSE

sourceexists = true

; mysql OR mssql
sourcedatabasetype = mysql
sourceserver = sourceserver
sourceuser = ""
sourcepassword = ""
sourcedatabase = agora
sourcetableprefix = clientservicesmidwestregion


-----
I have blanked user pass and server name to protect the innocent.
Any ideas?
I have used impex successfully in the past with other forums.

[misaochankun]

Import / Export

Database cleanup & restart (http://umgit-forums:8080/impex/help.php) ||| Online manual (../docs/html/impex)


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.


moderator - importmoderatorid OK
usergroup - importusergroupid OK
ranks - importrankid OK
poll - importpollid OK
forum - importforumid OK
forum - importcategoryid OK
user - importuserid OK
style - importstyleid OK
thread - importthreadid OK
post - importthreadid OK
thread - importforumid OK
smilie - importsmilieid OK
pmtext - importpmid OK
avatar - importavatarid OK
customavatar - importcustomavatarid OK
customprofilepic - importcustomprofilepicid OK
post - importpostid OK
attachment - importattachmentid OK
pm - importpmid OK
agora NOT found or a non standard table.
agora_userforum NOT found or a non standard table.
agora_users NOT found or a non standard table.
clientservicesmidwestregion NOT found or a non standard table.
clientservicesmidwestregion_attachments NOT found or a non standard table.
clientservicesmidwestregion_citrix NOT found or a non standard table.
clientservicesmidwestregion_csmanagers NOT found or a non standard table.
clientservicesmidwestregion_exceptionreports NOT found or a non standard table.
clientservicesmidwestregion_fdcdr NOT found or a non standard table.
clientservicesmidwestregion_infrastructuresecurity NOT found or a non standard table.
clientservicesmidwestregion_nadr NOT found or a non standard table.
clientservicesmidwestregion_navrollout NOT found or a non standard table.
clientservicesmidwestregion_ntleads NOT found or a non standard table.
clientservicesmidwestregion_nycit NOT found or a non standard table.
clientservicesmidwestregion_nyserversupport NOT found or a non standard table.
clientservicesmidwestregion_orderentry NOT found or a non standard table.
clientservicesmidwestregion_orderlink NOT found or a non standard table.
clientservicesmidwestregion_programming NOT found or a non standard table.
clientservicesmidwestregion_serverconsolidation NOT found or a non standard table.
clientservicesmidwestregion_serversteering NOT found or a non standard table.
clientservicesmidwestregion_test NOT found or a non standard table.
clientservicesmidwestregion_ucdr NOT found or a non standard table.
clientservicesmidwestregion_umvdrelocations NOT found or a non standard table.
clientservicesmidwestregion_userforum NOT found or a non standard table.
clientservicesmidwestregion_users found.
clientservicesmidwestregion_userthread found.
clientservicesmidwestregion_ussoftwareinventory NOT found or a non standard table.
clientservicesmidwestregion_wwpdr NOT found or a non standard table.
clientservicesmidwestregion_zenappchanges NOT found or a non standard table.

vBulletin v3.0.6, Copyright ©2000-2005, Jelsoft Enterprises Ltd. (../)

myvar = ""; timeout = 50; function exec_refresh() { window.status="Redirecting"+myvar; myvar = myvar + " ."; timerID = setTimeout("exec_refresh();", 100); if (timeout > 0) { timeout -= 1; } else { clearTimeout(timerID); window.status=""; window.location="index.php"; } } exec_refresh();

[Floris]

try as prefix:
clientservicesmidwestregion_

instead of:
clientservicesmidwestregion

[misaochankun]

try as prefix:
clientservicesmidwestregion_

instead of:
clientservicesmidwestregion

I have done so, have a look though:








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.


moderator - importmoderatorid OK
usergroup - importusergroupid OK
ranks - importrankid OK
poll - importpollid OK
forum - importforumid OK
forum - importcategoryid OK
user - importuserid OK
style - importstyleid OK
thread - importthreadid OK
post - importthreadid OK
thread - importforumid OK
smilie - importsmilieid OK
pmtext - importpmid OK
avatar - importavatarid OK
customavatar - importcustomavatarid OK
customprofilepic - importcustomprofilepicid OK
post - importpostid OK
attachment - importattachmentid OK
pm - importpmid OK
agora NOT found or a non standard table.
agora_userforum NOT found or a non standard table.
agora_users NOT found or a non standard table.
clientservicesmidwestregion NOT found or a non standard table.
clientservicesmidwestregion_attachments NOT found or a non standard table.
clientservicesmidwestregion_citrix NOT found or a non standard table.
clientservicesmidwestregion_csmanagers NOT found or a non standard table.
clientservicesmidwestregion_exceptionreports NOT found or a non standard table.
clientservicesmidwestregion_fdcdr NOT found or a non standard table.
clientservicesmidwestregion_infrastructuresecurity NOT found or a non standard table.
clientservicesmidwestregion_nadr NOT found or a non standard table.
clientservicesmidwestregion_navrollout NOT found or a non standard table.
clientservicesmidwestregion_ntleads NOT found or a non standard table.
clientservicesmidwestregion_nycit NOT found or a non standard table.
clientservicesmidwestregion_nyserversupport NOT found or a non standard table.
clientservicesmidwestregion_orderentry NOT found or a non standard table.
clientservicesmidwestregion_orderlink NOT found or a non standard table.
clientservicesmidwestregion_programming NOT found or a non standard table.
clientservicesmidwestregion_serverconsolidation NOT found or a non standard table.
clientservicesmidwestregion_serversteering NOT found or a non standard table.
clientservicesmidwestregion_test NOT found or a non standard table.
clientservicesmidwestregion_ucdr NOT found or a non standard table.
clientservicesmidwestregion_umvdrelocations NOT found or a non standard table.
clientservicesmidwestregion_userforum NOT found or a non standard table.
clientservicesmidwestregion_users NOT found or a non standard table.
clientservicesmidwestregion_userthread NOT found or a non standard table.
clientservicesmidwestregion_ussoftwareinventory NOT found or a non standard table.
clientservicesmidwestregion_wwpdr NOT found or a non standard table.
clientservicesmidwestregion_zenappchanges NOT found or a non standard table.


Current table list:

+----------------------------------------------------+
| Tables_in_agora |
+----------------------------------------------------+
| agora |
| agora_userforum |
| agora_users |
| clientservicesmidwestregion |
| clientservicesmidwestregion_attachments |
| clientservicesmidwestregion_citrix |
| clientservicesmidwestregion_csmanagers |
| clientservicesmidwestregion_exceptionreports |
| clientservicesmidwestregion_fdcdr |
| clientservicesmidwestregion_infrastructuresecurity |
| clientservicesmidwestregion_nadr |
| clientservicesmidwestregion_navrollout |
| clientservicesmidwestregion_ntleads |
| clientservicesmidwestregion_nycit |
| clientservicesmidwestregion_nyserversupport |
| clientservicesmidwestregion_orderentry |
| clientservicesmidwestregion_orderlink |
| clientservicesmidwestregion_programming |
| clientservicesmidwestregion_serverconsolidation |
| clientservicesmidwestregion_serversteering |
| clientservicesmidwestregion_test |
| clientservicesmidwestregion_ucdr |
| clientservicesmidwestregion_umvdrelocations |
| clientservicesmidwestregion_userforum |
| clientservicesmidwestregion_users |
| clientservicesmidwestregion_userthread |
| clientservicesmidwestregion_ussoftwareinventory |
| clientservicesmidwestregion_wwpdr |
| clientservicesmidwestregion_zenappchanges |
+----------------------------------------------------+

[Jerry]

Use the table prefix "agora" and ignore the warnings.

[misaochankun]

Use the table prefix "agora" and ignore the warnings.

Database error in vBulletin:ImpEx Source 3.0.6:

Invalid SQL:
SELECT *
FROM agora_users
ORDER BY cle
LIMIT 0,500
mysql error: Unknown column 'cle' in 'order clause'

mysql error number: 1054

[misaochankun]

Import / Export

Database cleanup & restart (http://umgit-forums:8080/impex/help.php) ||| Online manual (../docs/html/impex)


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.


moderator - importmoderatorid OK
usergroup - importusergroupid OK
ranks - importrankid OK
poll - importpollid OK
forum - importforumid OK
forum - importcategoryid OK
user - importuserid OK
style - importstyleid OK
thread - importthreadid OK
post - importthreadid OK
thread - importforumid OK
smilie - importsmilieid OK
pmtext - importpmid OK
avatar - importavatarid OK
customavatar - importcustomavatarid OK
customprofilepic - importcustomprofilepicid OK
post - importpostid OK
attachment - importattachmentid OK
pm - importpmid OK
agora NOT found or a non standard table.
agora_userforum NOT found or a non standard table.
agora_users found.
clientservicesmidwestregion NOT found or a non standard table.
clientservicesmidwestregion_attachments NOT found or a non standard table.
clientservicesmidwestregion_citrix NOT found or a non standard table.
clientservicesmidwestregion_csmanagers NOT found or a non standard table.
clientservicesmidwestregion_exceptionreports NOT found or a non standard table.
clientservicesmidwestregion_fdcdr NOT found or a non standard table.
clientservicesmidwestregion_infrastructuresecurity NOT found or a non standard table.
clientservicesmidwestregion_nadr NOT found or a non standard table.
clientservicesmidwestregion_navrollout NOT found or a non standard table.
clientservicesmidwestregion_ntleads NOT found or a non standard table.
clientservicesmidwestregion_nycit NOT found or a non standard table.
clientservicesmidwestregion_nyserversupport NOT found or a non standard table.
clientservicesmidwestregion_orderentry NOT found or a non standard table.
clientservicesmidwestregion_orderlink NOT found or a non standard table.
clientservicesmidwestregion_programming NOT found or a non standard table.
clientservicesmidwestregion_serverconsolidation NOT found or a non standard table.
clientservicesmidwestregion_serversteering NOT found or a non standard table.
clientservicesmidwestregion_test NOT found or a non standard table.
clientservicesmidwestregion_ucdr NOT found or a non standard table.
clientservicesmidwestregion_umvdrelocations NOT found or a non standard table.
clientservicesmidwestregion_userforum NOT found or a non standard table.
clientservicesmidwestregion_users NOT found or a non standard table.
clientservicesmidwestregion_userthread NOT found or a non standard table.
clientservicesmidwestregion_ussoftwareinventory NOT found or a non standard table.
clientservicesmidwestregion_wwpdr NOT found or a non standard table.
clientservicesmidwestregion_zenappchanges NOT found or a non standard table.

[Jerry]

Database error in vBulletin:ImpEx Source 3.0.6:

Invalid SQL:
SELECT *
FROM agora_users
ORDER BY cle
LIMIT 0,500
mysql error: Unknown column 'cle' in 'order clause'

mysql error number: 1054

Do you have a hacked or latered database, cle should be the ordering id in the users table.

[misaochankun]

To my knowledge, the forum is a standard agora forum.
I can supply table defs if needed.

[Jerry]

To my knowledge, the forum is a standard agora forum.
I can supply table defs if needed.

If you could PM a link to a mysqldump so that I can down it and check it out that would be best.

[misaochankun]

I have attached the files.
WS02 is the file for what we have been talking about so far.
WS04 is another agora forum with similar problems.
This is just the table creation statements, so it's not too big.

[misaochankun]

Does the schema scare people or something? :D

[Jerry]

Nope, I'm just busy, I'll have a look at it now :)

[misaochankun]

Any clues yet? Need anything further?
This is definately a hot item here at my company, as we'd really like to move the last remaining non-forums on to vbulletin.

[Jerry]

My bad, been uber busy :o

Will put this on the todo list for tomorrow :)

[Jerry]

What version of agora is this schema from ?

The importer was written for 4.1.7.

The only diffrence I can find with out testing with data is the get_agora_user_details() in impex/systems/agora/000.php

Line 307, the SQL by should be :

$sql = "
SELECT *
FROM " . $tableprefix . "_users
ORDER BY userid
LIMIT " . $start_at . "," . $per_page;


Then the array index on line 319 should be :


$return_array["$user[userid]"] = $user;


Basically there is no cle index any more on users.

[misaochankun]

My best bet is that this is agora 4.1.2, by looking at the upgrade files in the tools directory.

The page itself does not show a version number anywhere.

[misaochankun]

Ok, perhaps I was way off.

w-agora version 4.0.1

database backend: mysql
set up on: Mar 08 2001

[misaochankun]

My attempts to upgrade to the 'newer' agora have failed so far.
Anyone have any advice?