Error creating tables

Submitted by Walshie on Sun, 2011-02-27 23:11 in Price Tapestry

Hi David,

I recently bought the script for my latest project, after using many similar scripts for the last year this definitely looks the best yet!

I'm having a problem whilst installing locally .I'm using xampp running apache and mysql.

I've set the databases up etc and on the setup.php screen everything passes apart from the "checking database tables" but i am prompted to install the tables. I click this and nothing happens. I've enabled database debug mode in config.advanced.php and i'm prompted with the following:

Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\wordpress\PriceTapestry\includes\database.php:55) in C:\xampp\htdocs\wordpress\PriceTapestry\setup.php on line 44

Any ideas?

Cheers
Chris

Hello Chris, The "Cannot

Submitted by support on Mon, 2011-02-28 08:59

Hello Chris,

The "Cannot modify header" message indicates that database debug mode did actually generate some output - line 55 is where any error during database_queryModify is output. Can you check for any further information on the page and let me know what is displayed, even if just perhaps:

[][]

...as this would indicate that setup.sql could not be opened. If you do see just the square brackets on their own can you double check that setup.sql is present in your installation folder...

Hope this helps!

Cheers,
David.
--
PriceTapestry.com

Hi Chris, Just an additional

Submitted by support on Mon, 2011-02-28 11:11

Hi Chris,

Just an additional thought - make sure that the username, whilst having access to the database also has CREATE, UPDATE and DELETE permissions, as if not that would explain why the database connection and access tests pass, but the tables could not be created...

Cheers,
David.
--
PriceTapestry.com

Thanks David, i'll try this.

Submitted by Walshie on Mon, 2011-02-28 17:12

Thanks David, i'll try this. I've checked and the SQL is executing so like you said it would suggest the permissions are incorrect.

I'll let you know

Cheers
Chris

Problem solved. It turned

Submitted by Walshie on Mon, 2011-02-28 19:43

Problem solved. It turned out the version of myphpadmin that was supplied with xampp was 5.1 and required the sql changing. Instead of "TYPE=MyISAM" this had to be replaced with "Engine=MyISAM"

Cheers
Chris

Thanks for the info,

Submitted by support on Tue, 2011-03-01 09:32

Thanks for the info, Chris!

Cheers,
David.
--
PriceTapestry.com