News:

LVCS.NET offers low cost domain registration services.

Main Menu
Menu

Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Show posts Menu

Topics - whiteknight

#1
Support Requests / mysql_connect
February 17, 2007, 02:16:09 AM
First, I would like to say that I know this isn't exactly the right place for this posting.  I have an account with Freepgs and purchased additional hosting from LVCS.  So far it has been a little problomatic getting things up there.  One of the errors I'm getting is this:

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/b/u/m/bumpsarcade/html/arcade/config.php on line 11
Could not connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

I have an arcade that I host through Freepgs.  I'm also trying to get this up at LVCS.  When I go to dump data into MySQL I get this:

Error

SQL query:

CREATE TABLE `ava_settings` (
`site_name` text NOT NULL ,
`site_url` text NOT NULL ,
`template_url` text NOT NULL ,
`max_results` text NOT NULL ,
`image_height` text NOT NULL ,
`image_width` text NOT NULL ,
`adsense` char( 1 ) NOT NULL default '',
`cat_numbers` char( 1 ) NOT NULL default '',
`seo_on` char( 1 ) NOT NULL default '',
`email_on` char( 2 ) NOT NULL default ''
) ENGINE = MYISAM DEFAULT CHARSET = latin1;

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 12


This is the very same one I'm using at freepgs without any problems.  I looked the syntax up and it appears to be correct.  Somebody please help.