Need help to restore a data base

[hsmom13]

I moved my store from Start Logic Hosting to GoDaddy. Here are the steps I took:

1. Made a back up of the database from the Admin on the Start Logic site and downloaded to my pc.

2. Did a fresh install of OSC from the GoDaddy applications and created a blank database

3. Renamed the database to the name supplied by GoDaddy

4. Used FTP with Filezilla to move the db into the Admin/backups file

5. Went to Admin-->Tools-->Database to do a restore and clicked the right restore button.

6. Got this error message: Fatal error: Call to undefined function: stripos() in /home/content/h/c/r/hcraw2008/html/catalog/admin/backup.php on line 252

 

I found stripos one time, but I don't know if it is line 252, nor what to do with it. Very close to it, I found strpos twice, and don't know if this makes a difference. Here is the code from a few lines above and below. (Actually, thoughout the whole file there are numerous occurrences of strpos. Does that mean that the "i" should be deleted from the line below?)

 

How does one know what line number we are on?

 

}

}

if ($next == '') { // get the last insert query

$next = 'insert';

}

if ( (eregi('create', $next)) || (eregi('insert', $next)) || (eregi('drop t', $next)) ) {

$query = substr($restore_query, 0, $i);

 

$next = '';

$sql_array[] = $query;

$restore_query = ltrim(substr($restore_query, $i+1));

$sql_length = strlen($restore_query);

$i = strpos($restore_query, ';')-1;

 

if (eregi('^create*', $query)) {

$table_name = trim(substr($query, stripos($query, 'table ')+6)); $table_name = substr($table_name, 0, strpos($table_name, ' '));

 

$drop_table_names[] = $table_name;

}

}

 

 

Thanks and blessings,

 

hsmom13

[Guest]

http://www.google.com.hk/search?hl=en&...mp;aq=f&oq=

 

http://www.google.com.hk/search?hl=en&...mp;aq=f&oq=

 

or

 

 

strpos

 

(PHP 4, PHP 5)

 

strpos — Find position of first occurrence of a string

 

 

and

 

 

stripos

 

(PHP 5)

 

stripos — Find position of first occurrence of a case-insensitive string

 

Looks like your PHP is incomplete and/or php4

 

create a file like this:

 

<?php

 

phpinfo();

 

?>

 

Save it on your server, run it and note the output.

 

99% you are not running PHP 5 on your new host. Welcome to OSCommerce/PHP incompatibility land!

 

Graham Leach, Co-Proprietor

Authentic Closet

[hsmom13]

http://www.google.com.hk/search?hl=en&...mp;aq=f&oq=

 

http://www.google.com.hk/search?hl=en&...mp;aq=f&oq=

 

or

 

 

strpos

 

(PHP 4, PHP 5)

 

strpos — Find position of first occurrence of a string

 

 

and

 

 

stripos

 

(PHP 5)

 

stripos — Find position of first occurrence of a case-insensitive string

 

Looks like your PHP is incomplete and/or php4

 

create a file like this:

 

<?php

 

phpinfo();

 

?>

 

Save it on your server, run it and note the output.

 

99% you are not running PHP 5 on your new host. Welcome to OSCommerce/PHP incompatibility land!

 

Graham Leach, Co-Proprietor

Authentic Closet

 

 

Graham,

 

Thank you for your reply. Unfortunately, I don't know enough about code to really grasp the referenced discussion. I do know that my server has PHP 4, with the option of moving to 5. If I do that will the problem be solved?

 

Thanks

 

hsmom13