Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

just moved servers! advice help needed!


t4evay2k

Recommended Posts

hey guys

 

currently have an oscommerce shop

 

just moved server and transfered everything over.... all went smoothly BUT

 

this error appears :

 

1146 - Table 't4evay2k_osc1.configuration' doesn't exist

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

can be viewed: http://www.gsmsuper.co.uk/mobile-phone-accessory/

 

 

my old server login was 'gsms' my new one is 't4evay2k' on the new server --

meaning mysql databases have changed from gsm_osc1 to t4evay2k_oc1

 

ive editted: /public_html/includes/configure.php

and

/public_html/admin/includes/configure.php

 

and editted mysql database (replaces all gsms with t4evay2k)

 

i uploaded the edited version of the mysql via myphpadmin however this error appeared:

 

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 'DEFAULT CHARSET=latin1' at line 17

 

here are first 20 lines of mysql db:

 

-- MySQL dump 10.9

--

-- Host: localhost Database: t4evay2k_osc1

-- ------------------------------------------------------

-- Server version 4.1.18-standard

 

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

 

 

any advice and help much appreciated

 

kindest regards

 

ant

Link to comment
Share on other sites

In the future do not provide database login details for security reasons.

 

Edit your .sql dump file and remove all of the DEFAULT CHARSET=latin1 entries. It would be best to use a Replace All feature of an editor for this.

 

Then try to upload your .sql file again and that should get you going.

"Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein

Link to comment
Share on other sites

In the future do not provide database login details for security reasons.

 

Edit your .sql dump file and remove all of the DEFAULT CHARSET=latin1 entries. It would be best to use a Replace All feature of an editor for this.

 

Then try to upload your .sql file again and that should get you going.

 

 

cheers jim,

 

you the man!

 

 

 

thanks

Link to comment
Share on other sites

just noticed another problem :(

 

tried getting on admin section:

 

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

 

Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

 

More information about this error may be available in the server error log.

 

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

 

 

any ideas?

Link to comment
Share on other sites

just noticed another problem :(

 

tried getting on admin section:

 

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

 

Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

 

More information about this error may be available in the server error log.

 

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

any ideas?

You need to check your server error logs - the details of the error will be recorded in there. The 404 can be ignored - that doesn't mean anything. The key is the entry in the server error log as it will give you more details. Terra

My code for combining PayPal IPN with ** QTPro 4.25 ** osC Affiliate ** CCGV(trad)

and how to solve the invoice already paid error

General info: Allow customer to delete order comment ** FTP Programs & Text Editors ** Amending order email **

Link to comment
Share on other sites

Terra is correct in that the error_log will contain the exact problem.

 

That is usually due to a directive in the admin/.htaccess file that your host does not allow.

 

Look for any php_ directive and place a # at the beginning of the line and see if that doesn't resolve the issue.

"Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein

Link to comment
Share on other sites

You need to check your server error logs - the details of the error will be recorded in there. The 404 can be ignored - that doesn't mean anything. The key is the entry in the server error log as it will give you more details. Terra

 

 

hey thanks guys...

complete newb at php and osc

 

sorry if its a really stupid q but where and how do i check the server error logs>?

 

 

also jim ->

 

looked in my admin/.htaccess

 

and the only php_directives: are:

 

 

#<IfModule mod_php4.c>

# php_value session.use_trans_sid 0

# php_value register_globals 1

#</IfModule>

 

 

which all have # already in front of them

 

cheers guys your help is much appreciated

 

ant

 

ps vger which files shud i not have with premissions 777, and what should they be set to?

 

regards

Link to comment
Share on other sites

You shouldn't have any files with permissions of 777 at all. Files should be 644, with the exception of the two configure.php files which will be 644, 444 or 400 depending on server.

 

Folders should be 755.

 

Vger

Link to comment
Share on other sites

Vger is correct except for the following:

images

admin/backups

admin/images/graphs

 

which should have 777 permissions.

"Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...