php help

[caelan]

i got this message installing a php / mysql database... any ideas??? i think i need the php v3... or is it somthing else

Query for entries has failed CREATE TABLE `TTS_entries` ( entries_id mediumint(8) NOT NULL auto_increment, entries_ticket_id mediumint(8) NOT NULL default '0', entries_reply_to mediumint(8) NOT NULL default '0', entries_date int(25) NOT NULL default '0', entries_user_id mediumint(8) NOT NULL default '', entries_text text NOT NULL, PRIMARY KEY (entries_id) ) TYPE=MyISAM;.

Query for tickets has failed CREATE TABLE `TTS_tickets` ( tickets_id mediumint(8) NOT NULL auto_increment, tickets_status int(1) NOT NULL default '0', tickets_user_id mediumint(8) NOT NULL default '', tickets_tech_id mediumint(8) NOT NULL default '', tickets_pcat_id mediumint(8) NOT NULL default '', tickets_title char(50) NOT NULL default '', tickets_opened int(25) NOT NULL default '0', tickets_phone_number char(50) NOT NULL default '', tickets_system char(50) NOT NULL default '', tickets_serial char(50) NOT NULL default '', PRIMARY KEY (tickets_id) ) TYPE=MyISAM;.

 

[Brandon]

That's be from an SQL error. Have you tried running the queries through phpMyAdmin manually?

 

[caelan]

no im not that scriping handy but it did work on my other server (that was only a 60 day trial) could you lend a hand i have the files and everything youd need

 

[caelan]

ive attached the files should you choose to help :biggrin:

the site is openhand.pcriot.com/cs