Database Error on Install *CMS Warning line 75*

JJKKING · Operator Offline Joined: Jan 24, 2007 Posts: 25

Sorry to be a pain so quick.

My Specs

CMS Version 9.2.1
PHP Version 5.2.5
MySQL Version 5.0.51a-log (client: 5.0.32)

This isnt related to the issue I had with treasury and MySQL 5 is it?

Thanks again for everything

Got a database error on Install.

A Database Error has occurred.....

Code::

includes/db/db.php

    * CMS Warning line 75: On /admin.php?op=modules&install=DragonflyAds While executing query "CREATE TABLE cms_ads_ads ( id_ads int(11) NOT NULL auto_increment, id_catg mediumint(9) NOT NULL default '0', title varchar(255) NOT NULL default '', ads_desc text NOT NULL, imageads varchar(50) NOT NULL default '', curr tinyint(4) NOT NULL default '0', price decimal(11,2) NOT NULL default '0.00', submitter mediumint(9) NOT NULL default '0', submitip VARBINARY(17) NOT NULL, email varchar(50) NOT NULL default '', website varchar(50) NOT NULL default '', dateposted int(11) NOT NULL default '0', validuntil int(11) NOT NULL default '0', hits mediumint(9) NOT NULL default '0', language varchar(50) NOT NULL default '', active tinyint(4) NOT NULL default '0', feature tinyint(4) NOT NULL default '0', PRIMARY KEY (id_ads)) TYPE=MyISAM DEFAULT CHARSET=utf8" the following error occured: Table 'cms_ads_ads' already exists In: /homepages/28/d144494854/htdocs/ESB/clan/public_html/includes/classes/installer.php on line: 61

Phoenix

hmm, shouldn't be as it doesn't use the new installer - that error is saying you already have the table installed?

In any event, I'll do a test install on MySQL5 - it's been a while since I last installed it and that would have been on MySQL4 anyway. I expect your original problem was this

Code::

includes\db\db.php

    * CMS Warning line 75: On /921/admin.php?op=modules&install=DragonflyAds While executing query "CREATE TABLE cms_ads_comments ( no_comment int(11) NOT NULL auto_increment, id_ads int(11) NOT NULL default '0', commentby varchar(30) NOT NULL default '', subject varchar(200) NOT NULL default '', comment text NOT NULL, hostname varchar(50) NOT NULL default '', date int(10) UNSIGNED NOT NULL DEFAULT '.gmtime().', PRIMARY KEY (no_comment)) TYPE=MyISAM DEFAULT CHARSET=utf8" the following error occured: Invalid default value for 'date' In: C:\wamp\www\921\includes\classes\installer.php on line: 61

I should have done a test install Sad

pretty silly really because my local is set for MySQL Strict which is a perfect test vehicle.

Download updated - just remember to manually remove the existing cms_ads_* tables before re-installing.
nukebiz.com/Downloads/...ils/id=70/

JJKKING · Operator Offline Joined: Jan 24, 2007 Posts: 25

Opps Im sorry. Yeah I forgot to delete the tables before getting the error again.

All works fine with the new DL.

Thank you again for all your help.

Phoenix

You're most welcome, and many thanks for the contribution Very Happy

I won't be surprised if there are some further small glitches - I've been making bulk changes to bring it up to standard, which means I may make the occasional typo.

Phoenix

I recommend updating with the latest download.

No database changes involved but numerous file changes involving bug fixes, security fixes and further database query reductions.

Search and Advanced search is now especially functional.

JJKKING · Operator Offline Joined: Jan 24, 2007 Posts: 25

Thank you very much sir will do so as soon as I get home.

Phoenix

Download updated » nukebiz.com/Downloads/...ils/id=70/

Added extra fields to ads like country, state, city, keywords.

Database changes so you need to backup the ads db tables and to upgrade the module.

Also some bug fixes and numerous code enhancements.

JJKKING · Operator Offline Joined: Jan 24, 2007 Posts: 25

Got it thanks.