t4evay2k Posted May 31, 2006 Posted May 31, 2006 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
Daemonj Posted May 31, 2006 Posted May 31, 2006 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
t4evay2k Posted May 31, 2006 Author Posted May 31, 2006 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
t4evay2k Posted May 31, 2006 Author Posted May 31, 2006 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?
Terra Posted May 31, 2006 Posted May 31, 2006 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 **
Daemonj Posted May 31, 2006 Posted May 31, 2006 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
♥Vger Posted May 31, 2006 Posted May 31, 2006 Just a guess - but if any of your files have permissions of 777 (full permissions) then that could trigger the error. Vger
t4evay2k Posted May 31, 2006 Author Posted May 31, 2006 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
♥Vger Posted June 1, 2006 Posted June 1, 2006 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
Daemonj Posted June 2, 2006 Posted June 2, 2006 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
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.