Table 'million.blocks' doesn't exist

Started February 12, 2008 by dericsoon

dericsoon@dericsoon

Hi,

I have installed the script into my windows webserver but soon after the installation completed it show an error message below:

Error: BLOB/TEXT column 'alt_text' can't have a default value( CREATE TABLE blocks ( block_id int(11) NOT NULL default '0', user_id int(11) default NULL, status set('reserved','sold','free','ordered','nfs') NOT NULL default '', x int(11) NOT NULL default '0', y int(11) NOT NULL default '0', image_data text NOT NULL, url varchar(255) NOT NULL default '', alt_text text NOT NULL default '', file_name varchar(255) NOT NULL default '', mime_type varchar(100) NOT NULL default '', approved set('Y','N') NOT NULL default '', published set('Y','N') NOT NULL default '', currency char(3) NOT NULL default 'USD', order_id int(11) NOT NULL default '0', price float default NULL, banner_id int(11) NOT NULL default '1', ad_id INT(11) NOT NULL default '0', click_count INT NOT NULL, PRIMARY KEY (block_id,banner_id) )) 41 Operations Completed. Database successfully Installed. Next Steps:

Delete this file (install.php) from the server
Note: You must go to Admin->Main Config now and set up the rest of the script. Go to Admin. (The default admin password is 'ok'. Please don't forget to change the default password.)

Is there something wrong with my installation? I login to the pixel admin page and would like to approve Pixels but it show the message "Table 'million.blocks' doesn't exist". Please advise, what should I do to have this table in my admin page. If I have did something wrong in my istallation please help to correct me. Looking forward your reply. Thank you. Regards, Deric Soon

3 replies

krv@krv February 12, 2008

When I tried following the INSTALL instructions in the README.TXT file included with the script... Step One says:

Setup your database. Create a new database on your hosting account. (Make sure that your MYSQL database user has privileges to INSERT, UPDATE, REPLACE and LOCK TABLES.) My cPanel X does not have REPLACE included in it's list. I tried supstituting ALTER, but got the same ERROR as you show. I tested using ALL PRIVELEDGES, and it worked. You may want to tried different priveledges to find all that are required for the script to operate properly. I haven't tested each setting yet. But this should head you in the right direction. Good Luck

Ryan@ryan February 12, 2008

Looks like your are using MySQL 5 in strict mode. The script will only work in MySQL 4 or MySQL 5 with strict mode turned off.

Alty@alty February 12, 2008

And to do that if you are running MySql on your own server: Open your "my.ini" file within the MySQL installation directory, and look for the text "sql-mode". Find:

Set the SQL mode to strict

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" and replace it with:

Set the SQL mode to strict

sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"