41 "Sky_Rpg" (3.2.2) by Sky
Plugin loads but shows this error.
L 06/27/2012 - 02:20
6: [rpg3.3_store.smx] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1
L 06/27/2012 - 02:20
6: [rpg3.3_store.smx] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1
L 06/27/2012 - 02:20
6: [rpg3.3_store.smx] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1
L 06/27/2012 - 02:20
6: [rpg3.3_store.smx] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1
L 06/27/2012 - 02:20
6: [rpg3.3_store.smx] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1
and
L 06/27/2012 - 03:43:49: [rpg3.3_store.smx] Table 'rpg_rpg5.trails' doesn't exist
L 06/27/2012 - 03:43:49: [rpg3.3_store.smx] Table 'rpg_rpg5.trails' doesn't exist
L 06/27/2012 - 03:43:49: [rpg3.3_store.smx] Table 'rpg_rpg5.trails' doesn't exist
L 06/27/2012 - 03:43:49: [rpg3.3_store.smx] Table 'rpg_rpg5.trails' doesn't exist
L 06/27/2012 - 03:43:50: [rpg3.3_store.smx] Table 'rpg_rpg5.trails' doesn't exist
L 06/27/2012 - 03:43:50: [rpg3.3_store.smx] Table 'rpg_rpg5.trails' doesn't exist
L 06/27/2012 - 03:43:50: [rpg3.3_store.smx] Table 'rpg_rpg5.trails' doesn't exist
L 06/27/2012 - 03:43:50: [rpg3.3_store.smx] Table 'rpg_rpg5.trails' doesn't exist
L 06/27/2012 - 03:43:50: [rpg3.3_store.smx] Table 'rpg_rpg5.trails' doesn't exist
According to MySQL.com
The ENGINE and TYPE options specify the storage engine for the table. ENGINE was added in MySQL 4.0.18 (for 4.0) and 4.1.2 (for 4.1). It is the preferred option name as of those versions, and TYPE has become deprecated. TYPE is supported throughout the 4.x series, but likely will be removed in the future.
I found database.sp in the source attached to this thread but having problems compiling the rpg3.3.sp
getting errors like undefined symbol etc
Can anyone compile the rpg3.3.sp with this modified database.sp for TYPE> ENGINE amendement.