mariovaldez.net
http://www.mariovaldez.net/webapps/forums/

Error creation & error update
http://www.mariovaldez.net/webapps/forums/viewtopic.php?f=1&t=42
Page 1 of 1

Author:  jblanco [ 07 Jul 2003, 12:26 ]
Post subject:  Error creation & error update

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

Author:  mvaldez [ 07 Jul 2003, 22:27 ]
Post subject:  Error creation & error update

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.

Author:  jblanco [ 08 Jul 2003, 14:11 ]
Post subject:  Error creation & error update

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

Author:  mvaldez [ 09 Jul 2003, 03:03 ]
Post subject:  Error in database table creation...

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.

Author:  jblanco [ 09 Jul 2003, 09:24 ]
Post subject:  Error creation & error update

Mario,

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

Regards.
Jaime

Author:  mvaldez [ 16 Jul 2003, 20:47 ]
Post subject:  Error creation & error update...

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.

Author:  jusme [ 19 Oct 2003, 07:12 ]
Post subject:  DB Errors on install

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?

Author:  mvaldez [ 19 Oct 2003, 12:55 ]
Post subject:  DB Errors on install

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

Page 1 of 1 All times are UTC - 7 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/