plot
Sep 17 2005, 07:08 AM
| | Hey i got this error trying to install something on my database
CODE mysql 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 'rpg_class`
(`name`, `folder`, `regatt`, `magicatt`, `magicdef`
mysql error number: 1064
can anyone tell me what this means or how i fix it?? thanks in advance |
Reply
jipman
Sep 17 2005, 09:14 AM
Post a bit of the php code for the query, or else we can't help you much. Probably you used the wrong quotes around rpg_class.
Reply
Houdini
Sep 17 2005, 09:17 AM
Did the error occur whilst using phpMyAdmin or did it occur after you applied the new fields into a table? Are the new fields 'name`, `folder`, `regatt`, `magicatt`, `magicdef` actually in the table?
Reply
plot
Sep 17 2005, 11:21 PM
CODE $RPG_sql['install']['query']['rpg_class'] = "
CREATE TABLE `" . TABLE_PREFIX . "rpg_class`
(
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(20) NOT NULL default '',
`folder` varchar(50) NOT NULL default '',
`regatt` int(10) NOT NULL default '0',
`magicatt` int(10) NOT NULL default '0',
`magicdef` int(10) NOT NULL default '0',
`regdef` int(10) NOT NULL default '0',
`speed` int(10) NOT NULL default '0',
`evade` int(10) NOT NULL default '0',
`type` int(10) NOT NULL default '1',
`typename` varchar(30) NOT NULL default '',
`visible` smallint(5) NOT NULL default '1',
`gender` smallint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
";
$RPG_sql['install']['explain']['rpg_class'] = 'Created Table: <b><i>' . TABLE_PREFIX . 'rpg_class</i></b>'; im trying to install an integration hack into my board and the error occured wilst i was in the process of running the queries
Reply
jipman
Sep 18 2005, 01:45 PM
CODE
CREATE TABLE `" . TABLE_PREFIX . "rpg_class`
(
I'm not too sure, but haven't you forgot quotes around rpg_class, or maybe there's something like a space or whatever in your TABLE_PREFIX variable?
Reply
plot
Sep 18 2005, 09:57 PM
im not to sure, im not really keen on MySQL so i couldnt tell you if its right or not....i just follow the intstructions on the read-me... Ive posted this problem a few other places but this is the only place where i accually got a reply :-\ it would be nice if some more people gave a bit of thier knowledge
Reply
Similar Topics
Keywords : mysql, error
- Connecting To Astahost's Mysql
(8)
Mysql Server Not Stable After Hard Disk Swap On April 6th
(2) Hi... All are aware of the server issues happened on April 6th:
http://www.astahost.com/current-server-iss...ade-t15435.html I'm still facing the issue with
the MySQL Server after the server problems!! I'm using phpBB forum for my site, and it often
shows some error message after losing connection with the Database server! Its happening many times
in a minute! Its not at all stable after the server issues! I had tried repairing the databases and
optimizing the databases! But nothing helped me! Still facing the issues! Its showing like:
DEBUG MODE ....
Strange Error (maybe Directoryindex Glitch?)
(6) So if I browse to my site, www.ethergeek.com it takes me to a download window which proceeds to
download the PHP page from the server. If I type www.ethergeek.com/index.php the page loads as
expected. This happens in other folders too...it almost seems like if the server looks at
DirectoryIndex parameter it doesn't pass the page through the php preprocessor... Any ideas?....
Site Not Opeing ( Phpbb Forum) :: Can't Connect To Local Mysql
(3) Hi all, Please help me! My site was working fine! ( www.fun.niranvv.com ) But now, its showing
one error message as: Warning: mysql_connect() : Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (2) in
/home/niranvv/public_html/fun/db/mysql4.php on line 48 Warning: mysql_error(): supplied argument is
not a valid MySQL-Link resource in /home/niranvv/public_html/fun/db/mysql4.php on line 330 Warning:
mysql_errno(): supplied argument is not a valid MySQL-Link resource in
/home/niranvv/public_html/fun/db/mysql4.php on line....
Server Or Me?
I have an error? It doesn't look like anyone else has it? (5) OK I don't know if this is the right place for this so could the mods move it the the correct
place? Thanks. Whenever I try to access my website or log onto the control pannel I get the
following error message: QUOTE Network Error (tcp_error) A communication error occurred:
"Operation timed out" The Web Server may be down, too busy, or experiencing other problems
preventing it from responding to requests. You may wish to try again at a later time. For
assistance, contact your network support team. It says contact support team (I assume thats
you). Is an....
What Is The MySQL Version @ Asta ?
MySQL 4.0.26-Max
(16) Hi, A few question here, 1. Just wondering, the MySQL hosted on astahost.com is actually version
"4.0.26-Max" according to phpmyadmin. But why is cPanel showing "4.1.21-standard"? 2. Actually
i've existing codes that need function introduced after version 4.1.1, is there by any chance
astahost or xisto is going to upgrade the MySQL package? Thanks....
Problem With MySQL
(5) I tried to visit my website today and I recieved the dreadful page from my php-nuke site "There
seems to be a problem with the MySQL database" First I thought, "no big deal server is probably
rebooting or down for a little bit" So i logged into my cpanel and clicked on "Server Status".
Thats when I started worrying. It said the MySQL servers were up and runnign fine. I went back to my
main page and looked at my MySQL server count and instead of saying 2/99 it now says NA/99 I am
unable to create a new database and I recieve this error when I click on PHPmyadmin QUO....
Problems With cPanel
Showing some error message (9) Hi all, I was trying to upload some files to my account using cpanel! There was no problem in the
beginning! But suddently it shows one error message as: Sorry for the inconvenience!
The filesystem mounted at / on this server is running out of disk space. cPanel operation has been
temporarily suspended to prevent something bad from happening. Please ask your system admin to
remove any files not in use on that partition. (Edit: Authentication is working fine! After
authentication only, ith shows the error message like this! ) Please check this one: htt....
Php And Mysql Version.
(7) Is there any plan to upgrade or see if it can be upgraded to PHP5 and mySQL5 in the future?....
Mysql Connect Error, Too Many Connections.
(1) Just to begin with I want to say that I am not here necessarily to complain about it lol. I'm
not sure but if my site is possibly helping to contribute to the problem, I'd like to know if
anyone knows any good articles or tutorials that might have information on what to look out for that
could contribute to these sort of problems. I know my site may not have anything to do with it (as
I don't think it is overly popular or anything or even close), but knowing what to look out for
when messing with PHP/mySQL would be great. I personally haven't found too....
Mysql Error Never Seen On My Site Before (too Many Connections).
(13) I just tried to visit my site to see if anything had changed on my forums and such and I got this
message: Warning: mysql_connect(): Too many connections in /xxxx/xxxxx/xxxxxx_xxxxx/xxx/xx_xxxx.php
on line 7 Error! Could not connect: Too many connections. I have never recieved this error before,
does this mean someone is mucking with my site somehow??? The particular php file it mentions is
the one that defines variables like db username etc and connection to the site's database that I
include wherever it is needed in various file for the site. EDIT: I managed t....
Error Accessing Forum Topics
Can't access certain forum topics (1) Hi. I have been experiencing difficulty accessing certain forum topics. This started quite some time
back, but I always thought that the forum topics have been completely deleted, thus I'm not able
to access it. Now, however, I just saw a forum topic that I could not access previously being in the
last post column. I tried again but still I could not access it. The forum topic in this case is
"Shoutbox Display Names". Any help would be appreciated. Thanx.....
Site Unavailable!
Server Timeout error! (7) My Astahost Website seems to be unavailable currently. The Time is : 4:15 PM IST (GMT+5:30hrs)
The browser gives a "Server Timeout Error". Is this a temporary server downtime, or do I have to
re-configure my site or something? I also have enough credits to go on with - 17 at this time...
My site is : www.omkarshub.astahost.com ....
Help Me!
Frontpage & phpBB with MySQL (3) I was just approved an Astahost account with the starter package. I explored the Cpanel a bit
and have got the following problems : 1.Frontpage Extensions The Cpanel states that the
Frontpage Extensions have been installed. But when I uploaded my site on frontpage at
"ftp://ftp.mysitename.astahost.com/public_html/" it stated an error that Fronpage Extensions are not
installed on this server! When I opened my site online, I can see the page, but I cannot see any
graphics/images! Also, my forms and other stuff isn't working either. Please help me out and let
me....
Problems With PHP/Joomla On Hosted Site
PHP sevred pages are blank in Firefox, network error in Safari (7) I am having some odd problems with my hosted site. They started sometime yesterday. I have not made
any changes for about two weeks. In Firefox, the index page (index.php) for Joomla comes up blank.
I can access my Control Panel and can check that the files are there and look correct. No favorites
icon is displayed either and the page source is empty. In Safari, I get the favorites icon but then
get a network error and a blank page ("Safari can’t open the page “http://mistymanor.astahost.com/”.
The error was: “lost network connection” (NSURLErrorDomain:-1005) Please cho....
Mail Delevery System Error
error (6) whenever i try to send an email, no matter where, from any of the accounts that i create in cpanel,
i always get this error at the destinatary: QUOTE This message was created automatically by
mail delivery software. A message that you sent could not be delivered to one or more of its
recipients. This is a permanent error. The following address(es) failed: mustra@sapo.pt SMTP
error from remote mail server after MAIL FROM: SIZE=1668: host mx.ptmail.sapo.pt : 554 sorry,
your IP is rejected because it was flagged as an open-relay or abuser; o seu IP foi re....
Weird MySQL Message
(4) wenever i assign priviledges to a MySQL databases, it seems to work properly but this message is
always there QUOTE bitshift_wforumu (Privileges: ALL PRIVILEGES) Connection Strings
Perl $dbh = DBI->connect("DBI:mysql:bitshift_wforum:localhost","bitshift_wforumu"," ");
PHP $dbh=mysql_connect ("localhost", "bitshift_wforumu", " ") or die ('I cannot connect to the
database because: ' . mysql_error()); mysql_select_db ("bitshift_wforum"); My database
name is: bitshift_wforum the username is: bitshift_wforumu What does all that maen, it ....
Problem With MySQL Not Being Able To Connect
Anyone know the reason for this error... (9) Hello everyone, Im currently having a problem with mySQL, I wrote a PHP login script that
doesnt seem to be working for some reason. I created a database and everything looks correct, is
this a server issue or is the issue related to my script? But anyway this is my error, hope someone
can help Ive tried to search forum for answer but none of the posts seems to answer my question:
QUOTE Warning: mysql_connect(): Host 'gamma.xisto.com' is not allowed to connect to this
MySQL server in /home/hp2001/public_html/ucscKGD/checklogin.php on line 10 cannot co....
MySQL - Can't Connect
Cristal Report (1) From http://thoaionline.com (hosted by Astahost) QUOTE Warning: mysql_connect(): Can't
connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in
/home/pheart/public_html/thoaionline/includes/database.mysql.inc on line 31 Can't connect to
local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) In cPanel Mysql
databases 0 / 99 But I have 5 MySQL databases in my account (maybe more). All of them become
unusable now. Some more messages from http://website.thoaionline.com QUOTE Warning:
mysql_pc....
Can I Access MySQL Database From Outsite, Directly
(10) I'm going to make an OFFLINE FORUM. So I want to know is that possible or not. My paid host
don't allow that. How about astahost?....
Wrong Password/username - Fatal Error In Horde
(4) I keep getting a fatal error when trying to check my webmail using Horde, through the CPanel. Also,
when I try to open PhpMyAdmin I get an error saying "Wrong username/password. Access denied."
However, I'm logged into CPanel fine, and after getting this error I changed my password. That
went fine, as well. This is really annoying, I'm locked out of some stuff I sorta need access
too. Anyone able to help?....
IPS Driver Error / MySQL Database
What in the world? How is this possible? (1) Just several hours ago, I couldn't access my website/forum because of some error with an SQL
socket or something like that. I need desperate help because I don't want to reformat everything
again. Well, here is what comes up: IPB WARNING mysql_connect(): Can't connect to local
MySQL server through socket '/var/lib/mysql/mysql.sock' (2) (Line: 114 of
/ips_kernel/class_db_mysql.php) There appears to be an error with the database. You can
try to refresh the page by clicking here. Error Returned: SQL error: Can't connect to local
M....
MySQL Database
Important Report (3) I'm writing this to report about a error. One of my mySQL database has been droped and my site
stop working. I don't know the reason. I'm hosted on gamma server. I think you (admin)
should check it. PS: One of my paid hosting provider also met this problem a few day ago.....
Upgrade Error
Error while upgrading hosting account (3) Got this while trying to upgrade account .. Verfied.. Upgrading.. Connection Initilized... Secure
Socket Not Found. Continuing without SSL... Authorization Succeded.. Commands Executed.. Printing
out REturned DATA!. There were problems creating your account! Please Contact Administrator. And
it talks about bug info but doesnt show any .. so, err. Whats goin on?....
My Site
error accessing my site hosted here (5) Today at local time GMT+1 --> 15:12 I could not access my site http://www.final-design.net hosted
here at Astahost. error looks as follows: QUOTE The page cannot be displayed The page you are
looking for is currently unavailable. The Web site might be experiencing technical difficulties, or
you may need to adjust your browser settings. I hope you'll fix that soon. Thanks to
admins in advance.....
Php Parsing Error On Smf On My Site
Parse error: parse error, unexpected T_C (16) QUOTE Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in
/home/jeremy1/public_html/guild_forum/Sources/Subs.php on line 272 thats the error I get when
people try to access the forums I run on my website. I've been through the code but can't
figure out exactly whats wrong. I'm still quite new to PHP and still have a very limited
understanding of it. All I can say for certin is that up untill around 2 p.m. PST the forums were
working then around that time they seem to have stopped and started outputing that error message.
If anyone c....
Problem With Mysql
Cannot connect to database.... (6) Hi, this is the first time after I got my hosting to try and use MySQL. My site is
http://abhiram.astahost.com . I created a user in CPanel -> 'MySQL Databases' as root. So,
the new user created will be 'abhiram_root'. Similarly I created a database called
'webpage' (which changes to 'abhiram_webpage'). I set up the database and the tables
using phpMyAdmin and uploaded the files after making changes to the user name and the database. But
it's not opening the database. It's connecting to MySQL without any problems, but it
isn'....
MySQL Errors? - Error 13!
(0) Recently been attacked by "Can't create/write to file '/tmp/#sql_28e2_0.MYI' (Errcode:
13)"? Then its a simple fix, please DELETE (backup first) your SOURCE files that talk to the MySQL
database, and re-upload them This will purge them from the system and force them to recreate the
temporary files. Do NOT delete your database, just backup your files, delete them, re-upload them
and youll be fine. This is due to MySQL crash. Easily fixed and no data has been lost. Sorry guys
Details: MySQL crashed while writing data, it seems the temporary file has bee....
General Problems With New Account
MySQL problems and quota issues (2) I just got a new account and CPanel reports that I have -380.2 MB of quota space and using 400.2MB.
This disables some of Cpanel's functions. It would have been nice to use the automated Mambo
installer, but no biggy. I uploaded the latest Mambo .tar.gz from my FTP program and unpacked it
via Cpanel's file manager with no problem. When I first logged into the system I created a new
Database for mambo and a new user for that database and linked the two from Cpanel. I logged off to
watch something on TV and came back and that database isn't being reported....
Internal Server Error
500 Internal Server Error (6) I got the following error page when trying to access cpaanel and my cgi-bin: QUOTE Internal
Server Error The server encountered an internal error or misconfiguration and was unable to complete
your request. Please contact the server administrator, webmaster@coolbusinessideas.com 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 t....
Looking for mysql, error
|
*SIMILAR VIDEOS*
Searching Video's for mysql, error
|
advertisement
|
|
