| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Valtrinor
Sinister Defiance
Elitist Cowards
   |
Posted - 2008.09.27 12:28:00 -
[1]
Edited by: Valtrinor on 27/09/2008 12:35:16
Hi everyone, I'm also having an issue and hope you can be of assistance...
Error:
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 25
-- phpMyAdmin SQL Dump -- version 2.9.1.1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Dec 14,
2007 at 12:59 PM -- Server version: 5.0.45 -- PHP Version: 5.2.5 -- -- POS-TRACKER 3.0.0 -- $Id: install_database.sql 134
2008-08-03 21:25:18Z stephenmg $-- -- -------------------------------------------------------- -- -- Table structure for
table `pos2_alliance_info` -- CREATE TABLE `pos3_alliance_info` ( `allianceID` int(12) NOT NULL, `name` varchar(255) NOT
NULL, `shortName` varchar(255) NOT NULL, `updateTime` int(20) NOT NULL default '0', PRIMARY KEY (`allianceID`) )
ENGINE=MyISAM DEFAULT CHARSET=latin1
Problem?
I'm getting this at the second step of the install (install.php?step=2) on a fresh install and fresh database (I'd never had it before). All I can really tell from this is what the error message tells me regarding the location of the problem. Beyond that I'm an SQL newbie and not great with PHP yet. If there is any more info that will help please let me know. Unfortunately if a fix requires any kind of direct access to the MySQL server's config I'm out of luck, I'm using commercial hosting that doesn't give me that kind of access.
Thanks in advance!
-Valt
___________________
Valtrinor
Sinister Defiance
Elitist Cowards |
Valtrinor
Sinister Defiance
Elitist Cowards
|
Posted - 2008.09.28 10:12:00 -
[2]
 Quote:
It looks fine to me. I need more details about your setup.
Any specific details that would be of use? It's being set up on a site hosted by 1&1 on their 1&1 Home linux-based package. Nothing has been modified outside of necessary settings. Version being used is 3.0 beta 2b.
Server/Extension Versions:
Apache: Apache/1.3.34 Ben-SSL/1.55
PHP: 5.2.6
MySQL Client API: 5.0.32
Their server configuration puts the MySQL server at a separate IP from that of the web server, but the config has been adjusted to accommodate this. Outside of this information I can provide you a link to php, perl and python info pages (privately), or if you have specifics in mind let me know and I will do my best to find out. I don't have any kind of shell access to the box but if I need to I can contact their support to ask about the config.
___________________
Valtrinor
Sinister Defiance
Elitist Cowards |
Valtrinor
Sinister Defiance
Elitist Cowards
|
Posted - 2008.09.30 22:20:00 -
[3]
I'm now working with beta 3. I'm no longer getting the charset error, and everything seemed to be going well. Then I noticed the install script was stalling at "Creating/Updating tables" and not progressing or throwing errors. I let it sit for 12 hours to see if it was just going slowly and then used phpMyAdmin to check and see if it was putting anything into the database as it should be and it isn't. The database is still completely empty. It has not thrown any database connection errors but it seems to be failing to create tables and inject the data properly. This morning, for the sake of experimentation and troubleshooting I attempted to use the phpMyAdmin query window's Import Files page to import install_database.sql and received the following error (which may be unrelated to POS Tracker, but I want to provide anything that might help):
Error
SQL query:
-- phpMyAdmin SQL Dump
-- version 2.9.1.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 14, 2007 at 12:59 PM
-- Server version: 5.0.45
-- PHP Version: 5.2.5
--
-- POS-TRACKER 3.0.0
-- $Id: install_database.sql 176 2008-09-28 17:38:10Z stephenmg $--
-- --------------------------------------------------------
--
-- Table structure for table `pos2_alliance_info`
--
DROP TABLE IF EXISTS `%prefix%alliance_info`
MySQL said: Documentation
#1046 - No Database Selected
I am now also alternately receiving the charset error again through phpMyAdmin.
I'm starting to get the feeling that this might be a complication of the SQL server running on a different box that isn't externally accessible. Could all of this be due to a server-side issue I need to contact my host about? If you think so as well then I can always set up XAMPP or Apache2Triad on my Win Server 2003 box to test the theory.
On a side note, if anyone here also has hosting through 1&1 and has it working please contact me.
___________________
Valtrinor
Sinister Defiance
Elitist Cowards |
Valtrinor
Sinister Defiance
Elitist Cowards
|
Posted - 2008.10.01 09:17:00 -
[4]
Originally by: Johnathan Roark
Before you try importing with phpmyadmin, run a search and replace to replace all the %prefix% with what ever prefix you set in the dbconfig.php file. As far as the actual cause of your issue, im not sure, although I wonder if your bumping into the maximum script execution time limit.
After some more (figurative) banging my head against the wall in frustration I realized that it was probably something super-simple I had overlooked. I was trying to install it using MySQL 4 rather than MySQL 5 and had forgotten what I read about major syntax changes in version 5  . I made a new MySQL 5 DB and everything worked beautifully. Thank you for all the help and sorry for not thinking of this earlier!
___________________
Valtrinor
Sinister Defiance
Elitist Cowards |
| |
|