CPG 1.3 NOT working with php-4.3.10!!

[kegobeer]

Download the 1.3.2 zip and install it.  See if you get the same errors.

[tradenet]

OK something is VERY wrong with the CVS version.
I just downloaded the tar ball off of sourceforge and over wrote the files and all works fine...as it appears now.

[Rosely]

Ha ha ha.  That's a good one.  Coppermine corrupts the MySQL tables.  Never heard that one before.

Some versions of MySQL have trouble dealing with FULLTEXT which can lead to corruption.  There are also many other situations that can cause corruption.  Here's a good article that talks about it.

http://www.google.nl/search?q=Coppermine+There+was+an+error+while+processing+a+database+query&hl=nl&lr=&start=10&sa=N


hmm... is that mysql or coppermine???
we're using the newest stable version of MySQL and PHP.

[kegobeer]

What's the purpose of the link you provided?  If you want help, you need to provide a lot more information than just a quote and a link to a Google search.

[Rosely]

I'm sorry I wasn't clear.

I was pointing you to the enormous amount of people that have the same error and most of them don't know how to fix it.
They all have the error: "There was an error while processing a database query"

The same error I had and what means that a mysql table is corrupted. and which you can solve by repairing the table like I've written before.

I was trying to make you aware of how many people have the problem in the hope that you would see that this is a problem that Coppermine gives and that it isn't a problem in MySQL or PHP... And that hopefully you guys, the builders, the perfectionists (at least I would be if it were my product), would find a way to build your software around this problem.

[kegobeer]

That generic error is displayed in lieu of the actual MySQL error statement.  You have to enable debug output in order to see the actual error message.  I would wager less than one percent are the result of a corrupted table.

If you do some research on other database intesive apps, like SMF, phpBB, etc, you will see posts on those sites dealing with corrupted tables.

There is no "way around" this problem.  Coppermine, like the other apps, isn't responsible for a corrupted table.  Shared hosting, servers that can't handle the strain, old (beta, old, buggy, etc) versions of MySQL, and unforseen environmental problems can all contribue to a corrupted MySQL table.

We know that people sometimes encounter a corrupted table, you don't have to "make us aware" of that.  But we also know that Coppermine isn't the problem.

[Joachim Müller]

The same error I had and what means that a mysql table is corrupted. and which you can solve by repairing the table like I've written before.

Kegobeer is absolutely right, just to make this absolutely clear, let me repeat: the error message you quote does not necessarily mean your mySQL table is broken, it just means "there's something fishy related to the mySQL connection", but the reasons are manifold.
You just drew the wrong conclusions, your posting is irrelevant (and doesn't belong into this thread in the first place).

Joachim

[Rosely]

Well never mind then. Luckily I know how to fix the problem if it shows up again.

Other than that error Coppermine is great and I wanna say THANK YOU for sharing this gallery with us all.

Sorry for wrongposting, I thought it would be the right place as it talks about mysql errors and all.

Plus I just wanted to give people the solution to this problem as it shows up very often and this way (repair table) is the way to fix it (it worked for other people aswell.)

Shared hosting, servers that can't handle the strain, old (beta, old, buggy, etc) versions of MySQL, and unforseen environmental problems can all contribue to a corrupted MySQL table.

PS I just wanted to say: yeah, I have shared hosting but this server is far from full and really really up to date! (it's just been installed and all in september) besides we run the newest stable versions of all, it really can't be the server.

[Joachim Müller]

After all the mySQL data is stored on a hard drive, and a hard drive (even a brand new one) can fail. Just a few broken sectors on the hard drive can for example cause the MYI file to be broken. As an additional advice, I suggest you make backups both of your uploaded files and your database on a regular basis (this doesn't only apply to you, but anybody who has data on a webserver that is important).

Joachim

[nol33t]

Hi,
about the CVS problem mentionned above in this topic, i just did a fresh install ( cpg1.3.2 with TortoiseCVS, yesterday ), and apparently there's still a file missing:

"Warning: Invalid argument supplied for foreach() in config.php on line 368"

no biggie, i'm not asking for support here, just wanted to let you know

-matt-

[nol33t]

silly me that was due to the english.php file issue..