mariovaldez.net

Hi,

I'm having the following errors when I try to create the tables:

error creation CONTENT3
error update [table names]

Help me, please.
Jaime

Jaime:

> I'm having the following errors
> when I try to create the tables:
> error creation CONTENT3
> error update [table names]

Hi. Are you upgrading the CMS module? If so, then those warnings are harmless, just ignore them. This can also happen if you have already run the database tables creation script.

The problem is that the CMs module script has not reliable way to know if the database tables already exist or not, so it tries to create them anyway.

Regards,

Mario A. Valdez-Ramirez.

Mario,

this is a new install.

The full message is:
error creation CONTENT3
error update CONTENT3 1/7 to 0.5.0
error update CONTENT3 2/7 to 0.5.0
error update CONTENT3 3/7 to 0.5.0
error update CONTENT3 4/7 to 0.5.0
error update CONTENT3 5/7 to 0.5.0
error update CONTENT3 6/7 to 0.5.0
error update CONTENT3 7/7 to 0.5.0
error creation CMHITS3
error creation CMCOMMENTS3
error creation CMRATING3
error creation CMRESTRICT3
error creation CMAPPLOG3

Help. Maybe it is as you said, just a message.
Jaime

Jaime:

Hi again. Could you check the database tables with your SQL server management software. Please check if those tables (content3, cmhits3, cmrating3, etc) has been created or not.

What database are you using?


Regards,

Mario A. Valdez-Ramirez.

Mario,

These tables exist. I am using MySql. So, everything is working fine, right?

Regards.
Jaime

Jaime:

> These tables exist. I am using MySql.
> So, everything is working fine, right?

Yes. I guess you already found out.

Sorry for this late answer.


Mario A. Valdez-Ramirez.

I get the "error creating tables" but they're true. I can't seem to update the db when I run install. Is there a file that I could use to manually install my DB tables? If not, how can I get this to work?

jusme:

> I get the "error creating tables" but
> they're true. I can't seem to update
> the db when I run install. Is there a
> file that I could use to manually install
> my DB tables? If not, how can I get
> this to work?

Hi. Check with the database administration software (phpmyadmin, the MSSQL ent. manager, etc., whatever you use with your database) and verify if the tables already exists.

Those error messages are harmless if the tables already exists; just ignore them.

Currently, there is not an sql script to create this tables. There shouldn't be a need for one, as the PHP script is pretty reliable. What database system are you using? And what setup are you using (operative system, version of PHP and DB)?

Regards,

Mario A. Valdez-Ramirez