Error Message

[wcowart]

Hi,

I recently download Coppermine version: 1.4.4

Everything went fine...the install...the loading of the pictures, etc. Basically everything worked like it should for several days with no problems.

Today as I went to it I go this error message.

Error
SQL query: 

SELECT COUNT( * ) AS num
FROM `youngcel_coppermine`.`cpg143_albums`

MySQL said: 

#1033 - Incorrect information in file: './youngcel_coppermine/cpg143_albums.frm'


I'm a newbie so any help would be appreciated.

Wendell

[kegobeer]

First, contact your host and ask if they've done any MySQL upgrades/downgrades recently.  This problem is usually related to upgrading MySQL 4.1 from 4.0 (4.1 doesn't support the old 4.0 FRM format.)  You may be able to fix this by using phpMyAdmin and executing the following SQL command:

alter table cpg143_albums type=myisam;

As always, before doing any database work, make sure to back up your database!  Before doing any steps, contact your host as I said at the beginning of my post.

[wcowart]

Hi,

I called my host as you said and this is the information they gave me. No upgrades or anything recently.

mysql Ver 12.22 Distrib 4.0.18

PHP 4.4.2

I not sure how to fix the table. I know how to log into phpMyAdmin

Once there I see things like:

Show MySQL runtime information 
Show MySQL system variables   
Show processes   
Storage Engines 
Databases 
Export 
Import 
Log out 


Server: localhost   Database: youngcel_coppermine
Structure
SQL
Search
Query
Export
Import
Operations


Am I in the right location to execute this command?

[kegobeer]

Yes.  First: select your database, then export all the data (also export the table structure), then execute this SQL command:

check table cpg143_albums;

You should get that error message.  Then execute this command:

repair table cpg143_albums;

Do this again:

check table cpg143_albums;

If the problem is fixed, congratulations.  If not, you'll have to try the alter command I posted earlier.

[wcowart]

Sorry but you are going to have to be more specific. Besides downloading Coppermine that's all I know about databases and the like.

I do see the Export button at the PhpMyAdmin

I do see a select all button that highlights a bunch of files. In the list
SQL has a marker by it. At the bottom is a Go button.

Beyond that I don't see or know how to execute the command you've listed.

Is there a blank space I type that into. Is there some type of button I click once I do that?

Sorry, but this stuff is over my head.

Wendell