XS Orbit import

[tasman2]

Hi all . My club has been using an xsorbit 5 board for about three years . I have set up a new SMF 1.1.7 board  - (much better !). It is all set to go , except I cant   import the  posts etc from the xsorbit board .
I am an absolute mug when it comes to php , is there anyone who could do this import for me ? ( I have tried for 3 days ! ). The file I downloaded from xsorbit is about 6.5 meg .
Any assistance will be much appreciated.

[SleePy]

xsorbit is based off a very old version of SMF. You should be able to use SMF by just importing the database and then running the upgrade scripts

If you need more help with details on that I can go more in detail.

[tasman2]

Hi , thanks for your reply .
I have downloaded the sql file from xsorbit ( uncompressed) , it is now on my dextop .
Do I upload it via FTP to the  server ?
Where do i put it ? ( i have set SMF up as wwwroot/Forum )
Where do I find the upgrade scripts ?
Sorry for the "Dummy" questions , this has me beat

[ThorstenE]

you need to import the database dump first..

some useful links:
Restoring a Database
Upgrade SMF
What is repair_settings.php?

[JimM]

Welcome to SMF

I converted my Xsorbit board about 2 years ago.  As SleePy said, it is an older version of SMF so it's just a matter of getting the database installed, then running the large upgrade and you will be all set.

If you search for 'xsorbit' or 'xsorbit5' you will see several topics, where others have already done this with success.  I had a small issue with my database that I got help with here.  All that is contained in the topics that you will find by using the search.

[tasman2]

Hi again , and thanks for your help . I am still having problems :-( . I have read through a lot of relevant posts , and have tried -

removing Type= ( 33 occurrences )
the undefined index line at the start of each table (I think) -  ( 33 occurrences )
Have tried repair settings after an FTP transfer
and have had various error codes through phpmyadmin - this is the latest

SQL query:

# ==========================================================
#
# Database dump of tables in `agent86`
# January 12, 2009, 08:17:23 PM
#
# ==========================================================
#
# Table structure for table `agent86_attachments`
#
DROP TABLE IF EXISTS `agent86_attachments` ;

MySQL said: Documentation
#1046 - No database selected


Any ideas will be much appreciated - I am a mug at this
Thanks

[JimM]

You need to create a database with phpMyAdmin (What is phpMyAdmin?)  You normally do that within your hosting control panel.

Select that database prior to importing the data.

[tasman2]

Hi again , and thanks for your help...I feel like an idiot here.
I have created a database , run php admin and now get the following on php admin

SQL query:

ID_ATTACH int( 11 ) unsigned NOT NULL AUTO_INCREMENT , ID_MSG int( 10 ) unsigned NOT NULL default 0, ID_MEMBER int( 10 ) unsigned NOT NULL default 0, filename tinytext NOT NULL default '', size mediumint( 8 ) unsigned NOT NULL default 0, downloads mediumint( 8 ) unsigned NOT NULL default 0, PRIMARY KEY ( ID_ATTACH ) , KEY ID_MSG( ID_MSG ) , KEY ID_MEMBER( ID_MEMBER )
);

MySQL said: Documentation
#1064 - 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 'ID_ATTACH int(11) unsigned NOT NULL auto_increment,
  ID_MSG int(10) unsigned N' at line 1


I am stumped.......................

[tasman2]

Hi Jim ,
thanks for your offer to help , I really appreciate it.....I will attach
the file - (now only 1.4 meg - removed the error logs) as I downloaded it .
I am an absolute amateur when it comes to this stuff .
For some reason your email address is invalid ?
Tim

[JimM]

Do not attach your database here.  I'll give you another email address.

[tasman2]

Hi Jim.....email sent...thanks
Tim

[JimM]

Ok, got it working on it right now and will send it back shortly.  I see the problem.

[tasman2]

Thank you so much...............

[JimM]

OK, the file is on it's way back to you.  I had to edit it exactly like I did mine.  There is obviously a bug in the Xsorbit backup utility.

Basically I removed every instance of this:

Code Select Expand

<br />
<b>Notice</b>: Undefined index:  Type in <b>/home/xsorbit/public_html/users5/xxxxxxx/Sources/DumpDatabase.php</b> on line <b>303</b>

And additionally changed this:

Code Select Expand

) TYPE=;

to this:

Code Select Expand

) ;

You should be able to import the database without a hitch now!

[tasman2]

Much better , starting to work now. I have sent an email with the latest error code - thank you for your patience. I can't wait to be free of the other mob !

[JimM]

I know exactly how you feel.  Error fixed and new file emailed.

[tasman2]

Another email sent - the change to smf has been prompted by unexplained board downtime , particularly for the last 3 weeks - and lack of any kind of support from the other mob...........last one out turn off the lights ?

[JimM]

I'm working on it but can't seem to get the right combination for the log_time.  I've sent an PM but it may be tomorrow before I can get an answer.  We are so close.  I didn't have this problem at all and I'm thinking it may be something to do with the version of MySQL that your host is running.

[tasman2]

Thanks so much
Server is running Ver 5.0.51a-community

[JimM]

OK, just sent you a new one to try.  Here is the problem:

Code Select Expand

CREATE TABLE `agent86_log_online` (
  session varchar(32) NOT NULL default '',
  logTime timestamp default 'CURRENT_TIMESTAMP',             <----------- Errors here
  ID_MEMBER mediumint( unsigned NOT NULL default 0,
  ip int(11) unsigned NOT NULL default 0,
  url text NOT NULL default '',
  PRIMARY KEY (session),
  KEY online (logTime, ID_MEMBER),
  KEY ID_MEMBER (ID_MEMBER)
) ;


Here is what we are trying with this latest file.  This is what I get if I download my database (1.1.7)

Code Select Expand

CREATE TABLE `agent86_log_online` (
  session varchar(32) NOT NULL default '',
  logTime timestamp NOT NULL /*!40102 NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP */,
  ID_MEMBER mediumint( unsigned NOT NULL default 0,
  ip int(11) unsigned NOT NULL default 0,
  url text NOT NULL default '',
  PRIMARY KEY (session),
  KEY online (logTime, ID_MEMBER),
  KEY ID_MEMBER (ID_MEMBER)
) ;

If that don't work we may have to try something tomorrow.