While installing the hack, I noticed a few errors:
If you are using MyPHP V5 you will encounter a SQL error where it says you need to fix "TYPE=MyISAM"
You will need to edit the install.php file BEFORE the install and replace:
TYPE=MyISAM to
ENGINE=MyISAM
If too late, you can also go to your AdminCP and check your tables and edit each SQL entry.
For example:
If you see an error creating Shop_Cats
Go to the instal.php file and find:
Shop_Cats
You will see something like:
CREATE TABLE ".$tablepre."shop_cats (
id smallint(6) NOT NULL auto_increment,
cid smallint(6) NOT NULL default '0',
owner int(12) NOT NULL default '0',
catname varchar(100) NOT NULL default '',
description text NOT NULL,
displayorder int(10) NOT NULL default '0',
private varchar(30) NOT NULL default '1',
userlist text NOT NULL,
lastadd varchar(64) NOT NULL default '',
password varchar(32) NOT NULL default '',
status SET('on','off') NOT NULL default 'on',
creatoronly SET('on','off') NOT NULL default 'off',
views int(10) NOT NULL default '0',
items int(10) NOT NULL default '0',
ownermoney SET('on','off') NOT NULL default 'on',
PRIMARY KEY (id)
) TYPE=MyISAM
Edit the SQL to:
CREATE TABLE PREFIX_shop_cats (
id smallint(6) NOT NULL auto_increment,
cid smallint(6) NOT NULL default '0',
owner int(12) NOT NULL default '0',
catname varchar(100) NOT NULL default '',
description text NOT NULL,
displayorder int(10) NOT NULL default '0',
private varchar(30) NOT NULL default '1',
userlist text NOT NULL,
lastadd varchar(64) NOT NULL default '',
password varchar(32) NOT NULL default '',
status SET('on','off') NOT NULL default 'on',
creatoronly SET('on','off') NOT NULL default 'off',
views int(10) NOT NULL default '0',
items int(10) NOT NULL default '0',
ownermoney SET('on','off') NOT NULL default 'on',
PRIMARY KEY (id)
) ENGINE=MyISAM
Then go to your SQL data base and add:
CREATE TABLE PREFIX_shop_cats (
id smallint(6) NOT NULL auto_increment,
cid smallint(6) NOT NULL default '0',
owner int(12) NOT NULL default '0',
catname varchar(100) NOT NULL default '',
description text NOT NULL,
displayorder int(10) NOT NULL default '0',
private varchar(30) NOT NULL default '1',
userlist text NOT NULL,
lastadd varchar(64) NOT NULL default '',
password varchar(32) NOT NULL default '',
status SET('on','off') NOT NULL default 'on',
creatoronly SET('on','off') NOT NULL default 'off',
views int(10) NOT NULL default '0',
items int(10) NOT NULL default '0',
ownermoney SET('on','off') NOT NULL default 'on',
PRIMARY KEY (id)
) ENGINE=MyISAM
And press GO
You should see:
Your SQL query has been executed successfully
Go back to your AdminCP and check tables. Find any other tables that weren't correctly added and do the same process again.
Hope this helps anyone who may have issues installing.
TIP: It's easier to edit the the install.php
Find and REPLACE:
TYPE=MyISAM to ENGINE=MyISAM
I did this with 0 issues.
- Monique