infuse system script error - need help
hi, I have complete php and mysql code ready for install on my hosting server. those code is design for demo only. but it has errors on mysql table issue when i install on my server. I think the code of mySQL is design on old version when they create/ develop it on old version of mysql - demo only. I need someone can help me to convert it to install on my hosting server. so i can see the output of result. my hosting server is by Hostgator. I have this complete code in zip file format. if you are interest to check it to see can install on your hosting server. I can send to you.
and let me know you can help me to solve this errors? let me know ASAP if you can do this task. thank!Kevin
================================================== =======================================
> PHP version on Hostgator:5.3.27
> MySQL version: 5.5.23
================================================== =======================================
goto www.yourhost.com/infuser
after key in fields of username, password, database name, admin name & password... Show the following message:
================================================== =======================================
Infuser Site Installation Wizard
Step #1: Check Database Settings
Temporary Error
Right now this service is unavailble. We are experiencing a temporary error and will be fixed within 24 hours.
A complete report with this problem was already sent to our programmers and they are working on fixing it asap.
We apologise for this. Please try again later.
SITENAME Staff.
Database error: Invalid SQL: CREATE TABLE `a_tr` ( `id` int(10) unsigned NOT NULL auto_increment, `member_id` int(10) unsigned NOT NULL
default '0', `group_id` int(10) unsigned NOT NULL default '0', `amount` float(10,4) NOT NULL default '0.0000', `status` tinyint(1) unsigned default '0',
`comments` text, `dt` datetime default NULL, `product_id` int(11) NOT NULL default '0', `buyer_id` int(11) NOT NULL default '0', `session` varchar
(255) NOT NULL default '', `date_paid` datetime NOT NULL, `admin_note` varchar(255) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`),
KEY `id_2` (`id`,`member_id`,`group_id`,`status`,`dt`) ) ENGINE= MyISAM AUTO_INCREMENT = 1
MySQL Error:1050 Table 'a_tr' already exists
and let me know you can help me to solve this errors? let me know ASAP if you can do this task. thank!Kevin
================================================== =======================================
> PHP version on Hostgator:5.3.27
> MySQL version: 5.5.23
================================================== =======================================
goto www.yourhost.com/infuser
after key in fields of username, password, database name, admin name & password... Show the following message:
================================================== =======================================
Infuser Site Installation Wizard
Step #1: Check Database Settings
Temporary Error
Right now this service is unavailble. We are experiencing a temporary error and will be fixed within 24 hours.
A complete report with this problem was already sent to our programmers and they are working on fixing it asap.
We apologise for this. Please try again later.
SITENAME Staff.
Database error: Invalid SQL: CREATE TABLE `a_tr` ( `id` int(10) unsigned NOT NULL auto_increment, `member_id` int(10) unsigned NOT NULL
default '0', `group_id` int(10) unsigned NOT NULL default '0', `amount` float(10,4) NOT NULL default '0.0000', `status` tinyint(1) unsigned default '0',
`comments` text, `dt` datetime default NULL, `product_id` int(11) NOT NULL default '0', `buyer_id` int(11) NOT NULL default '0', `session` varchar
(255) NOT NULL default '', `date_paid` datetime NOT NULL, `admin_note` varchar(255) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`),
KEY `id_2` (`id`,`member_id`,`group_id`,`status`,`dt`) ) ENGINE= MyISAM AUTO_INCREMENT = 1
MySQL Error:1050 Table 'a_tr' already exists
Reviews: Need a good VPS, dedicated server, or unlimited host? (This is NOT a fake "top 10" list!)