Need Help In Resolving MySQL Database Crashes Need Help With The Subject Of Database

[stusrud 0]

Ok, I am not a genius when it comes to databaes, this topic is mostly reffering to "MySql" databases, I could use some help.On other free hosting sites, they give you MySql databases (maybe 2 or more) and I would set up phpnuke, vbulletin, phpbb, or anything else that needed a database, and when users started registering with my forums, the database would in a way "crash".Is this because some databases can only hold so much information, or what is causing this? I told you before, I do not know too much in the field of "databases" so sorry if you think this post is pointless.

Edited August 21, 2005 by microscopic^earthling (see edit history)

[unimatrix 0]

Define "crash". Would you get some error message from the application or would it crash the MySQLd service completely? I have before had issues with data in MySQL becoming corrupted on highly used datatables, which happens with all databases if you don't keep maintaince up. A little more detail could really help.

[miCRoSCoPiC^eaRthLinG 0]

Yup exactly - can't help you out anyway unless you elaborate more on your mysterious "crash"

[yordan 10]

I agree. We need to know how crash occurs.Did it crash from the very beginning, which means that there is an error in some of your programs or in the install.Or did it crash after some time of activity, which means maintenance work has to be done on your database (backup/restore, more space needed).

[Logan Deathbringer 0]

Without more information, such as the error your getting, the only idea I can come up with inregards to your problem is that maybe your forum is addressing the database/table/colum/whatever incorrectly and in doing so it causes corruption which in turn causes the database to "crash".

[stusrud 0]

Sorry, I just set up my forums, when alot of people register, it says an error like "Error in MySql, in file common.php, on line "?"Then I can't access my forums.

[Houdini 0]

That is an sql error that can be caused by a number of things, make sure that you have the proper chmod for your files, make sure that they are all there, and you might want to drop your database and reinstall it, if you can't login then it either can't find the authors table (if it its PHP_Nuke or phpBB2) and the only sql query in the common.php is below verbatim:

$sql = "SELECT *[tab][/tab]FROM " . CONFIG_TABLE;if( !($result = $db->sql_query($sql)) ){[tab][/tab]message_die(CRITICAL_ERROR, "Could not query config information", "", __LINE__, __FILE__, $sql);}while ( $row = $db->sql_fetchrow($result) ){[tab][/tab]$board_config[$row['config_name']] = $row['config_value'];

So the problem is probably a session problem but this might be because of the above stated improper file permissions. The common,php is used by phpBB as well as PHP-Nuke which uses phpBB for the Forums. If you are using phphBB and getting this error then probably you should look at the phpBB home page concerning file permissions.

 

I could check the file permissions in the C Panel or with your FTP client, if you are using PHP-Nuke then go HERE and read about file permissions and while within that area the read on, it is the full manual for PHP-Nuke.

[stusrud 0]

Ok, I will check it out and hopefull yiy won't do the same thing, but before also it had an error like, something to do with the database was full or something, then I couldn't use it and I had to completely redo my entire forums. Anyway thanks for the help! It's phpBB2 by the way, I want phpnuke, but I am still experimenting with it at the moment, since I am not too experienced in php!