No content being added, DB Issues

[Gonzo]

Hi,

I've just this evening attempted to update a client site. Very basic 1.4.1 Install running the Album module, the rest is standard.

First issue I noticed was that adding a new album refused to work - entering a name and submitting only brought in an existing album as if I had clicked that album to begin with.

Further investigation revealed adding new pages would work okay, but the content added dissappeared. At oen point however, nothign was being added, nor could I delete any newly created pages. I've been through several fresh installs to try figure this with no luck. From 1.4 - 1.6...

I've been snooping thru the DB, and have noticed that on any new page created, it's not adding anything to the 'prop_names' field, every other page has somethin to this extent: 'target,pagedata,extra1,extra2,extra3,content_en' If I add that manually via phpMyAdmin, the page comes right and the content sticks.

I haven't yet investigated the issue with the albums but the two issues seem to be related.

I'm desperately trying to avoid a fresh install and re-setting up all the pages & content, but looks like I'm going to have to if this isn't fixable - problem is, if it happens again I'm completely screwed...so far hours burned on this is around 8.

Has anybody has this problem? Is it a bug or something I'm missing? Any further required info let me know I'll flick it thru.

Cheers,

Gonzo

[Gonzo]

I've just discovered this error showing up on some of the DB tables - specific to the Album issue:

Error

SQL query: Documentation

SELECT *
FROM `cms_module_album_category_listings_seq`
LIMIT 0 , 1000

MySQL said: Documentation
#1033 - Incorrect information in file: '.\rrich\cms_module_album_category_listings_seq.frm'

So I'm guessing I'm dealin with some kind of corruption? From what littel research I've done on that error.

I also noticed adding a new album would automatically assign it an id of 0, and have been unable to add any new photos. Again, my best guess is that the tables have somehow crapped themselves.

[Dr.CSS]

Most times it is really helpful to give all the info about the versions of the server, php, mysql, etc. a lot of this is available in the system information page in the back end...

[alby]

#1033 - Incorrect information in file: '.\rrich\cms_module_album_category_listings_seq.frm'

Very bad error: table corrupt
Try to analyze and repair that table with phpmyadmin for example

Alby