 | error in easyMOD with Codecrush |  |
 Posted: 11/05/2006 8:47 PM |
 |
|
|
|
|
| Caravan |
| Posts |
282 |
| Word Cnt. |
31,380 |
| BDay |
Apr 14 |
| Sign |
Aries |
| Sex |
 |
|
|
|
Joined: Nov 01, 2006
Local time: 4:28 AM
Location: Denver, PA
|
|
|
|
|
 |
While trying to add Codecrush IP log I got the following SQL error in easyMOD. Even though it said I could continue, I did not. I simply discontinued the installation.
SQL PROCESSING ERROR:
No SQL alterations will be performed. However, you may skip SQL processing, continue installing the MOD, and deal with the SQL manually
The following error occured:
Error:
Unexpected or unknown attribute "PRIMARY KEY", in "config_name varchar(255) not null primary key default ___0___", statement: 1, table: "cc_ip_config"
SQL:
CREATE TABLE cc_ip_config(config_name varchar(255) not null primary key default '',config_value varchar(255) not null default '',config_desc varchar(255) not null default '') |
|
|
|
|
| Back to Top |
|
|
| Re: error in easyMOD with Codecrush | |
| Posted: 11/05/2006 9:06 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
 |
|
|
|
Joined: Sep 25, 2004
Local time: 4:28 AM
Location: St Pete, FL
|
|
|
|
|
|
Yep, the syntax is slightly wrong. The MOD author got it right on the last CREATE TABLE query though...
Ok, do this:
OPEN
ccip_easyMOD_install.txt
FIND
| Code:
|
#
#-----[ SQL ]------------------------------------------
#
CREATE TABLE cc_ip_config (config_name varchar(255) not null primary key default '', config_value varchar(255) not null default '', config_desc varchar(255) not null default '' );
CREATE TABLE cc_ip_log (log_nr INT UNSIGNED NOT NULL primary key auto_increment, logged BIGINT(14), username VARCHAR(25), user_ip VARCHAR(8), browser VARCHAR(128), proxy_ip text, user_id mediumint(8), referer VARCHAR(128), bb_ip VARCHAR(8), admin_login tinyint(1), page_id int(11) default '0', log_bit tinyint(2) default '0', flag tinyint(2) default '0', cusers varchar(255) default '' );
CREATE TABLE cc_ip_file (log_nr INT UNSIGNED NOT NULL primary key auto_increment, logged VARCHAR(64), username VARCHAR(25), user_ip VARCHAR(15), browser VARCHAR(128), admin_id MEDIUMINT(8) default '0', fproxy_ip text, user_id mediumint(8), referer VARCHAR(128), bb_ip VARCHAR(15), admin_login tinyint(1), page_id int(11) default '0', log_bit tinyint(2) default '0', flag tinyint(2) default '0', cusers varchar(255) default '' );
CREATE TABLE cc_ip_exc (exc_id mediumint(8) unsigned NOT NULL primary key auto_increment, username varchar(128) NOT NULL default '', browser varchar(128) NOT NULL default '', ip varchar(128) NOT NULL default '' );
CREATE TABLE cc_ip_bot( bot_id smallint(5) unsigned NOT NULL primary key auto_increment, browser_rev varchar(255) NOT NULL default '*', ip VARCHAR(15) NOT NULL default '*.*.*.*', robot VARCHAR(32), type VARCHAR(8) default 'bot', priority tinyint(2) unsigned default 0, image VARCHAR(64) );
CREATE TABLE cc_ip_sessions (md5_sum char(32) NOT NULL default '', session_start BIGINT(14), primary key(md5_sum) );
|
REPLACE WITH
| Code:
|
#
#-----[ SQL ]------------------------------------------
#
CREATE TABLE cc_ip_config (
config_name varchar(255) not null default '',
config_value varchar(255) not null default '',
config_desc varchar(255) not null default '',
PRIMARY KEY (config_name)
);
CREATE TABLE cc_ip_log (
log_nr INT UNSIGNED NOT NULL auto_increment,
logged BIGINT(14),
username VARCHAR(25),
user_ip VARCHAR(8),
browser VARCHAR(128),
proxy_ip text,
user_id mediumint(8),
referer VARCHAR(128),
bb_ip VARCHAR(8),
admin_login tinyint(1),
page_id int(11) default '0',
log_bit tinyint(2) default '0',
flag tinyint(2) default '0',
cusers varchar(255) default '',
PRIMARY KEY (log_nr)
);
CREATE TABLE cc_ip_file (
log_nr INT UNSIGNED NOT NULL auto_increment,
logged VARCHAR(64),
username VARCHAR(25),
user_ip VARCHAR(15),
browser VARCHAR(128),
admin_id MEDIUMINT(8) default '0',
fproxy_ip text,
user_id mediumint(8),
referer VARCHAR(128),
bb_ip VARCHAR(15),
admin_login tinyint(1),
page_id int(11) default '0',
log_bit tinyint(2) default '0',
flag tinyint(2) default '0',
cusers varchar(255) default '',
PRIMARY KEY (log_nr)
);
CREATE TABLE cc_ip_exc (
exc_id mediumint(8) unsigned NOT NULL auto_increment,
username varchar(128) NOT NULL default '',
browser varchar(128) NOT NULL default '',
ip varchar(128) NOT NULL default '',
PRIMARY KEY (exc_id)
);
CREATE TABLE cc_ip_bot(
bot_id smallint(5) unsigned NOT NULL auto_increment,
browser_rev varchar(255) NOT NULL default '*',
ip VARCHAR(15) NOT NULL default '*.*.*.*',
robot VARCHAR(32),
type VARCHAR(8) default 'bot',
priority tinyint(2) unsigned default 0,
image VARCHAR(64),
PRIMARY KEY (bot_id)
);
CREATE TABLE cc_ip_sessions (
md5_sum char(32) NOT NULL default '',
session_start BIGINT(14),
primary key(md5_sum)
);
|
Save, upload, and try again using EM...
 |
|
|
|
|
| Back to Top |
|
|
| Re: error in easyMOD with Codecrush | |
| Posted: 11/05/2006 9:53 PM |
|
|
|
|
|
| Caravan |
| Posts |
282 |
| Word Cnt. |
31,380 |
| BDay |
Apr 14 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Nov 01, 2006
Local time: 4:28 AM
Location: Denver, PA
|
|
|
|
|
|
*all 6 say the same thing
| Code:
|
6 Warning(s) reported by the SQL Parser
1. Identifier "type" is a reserved keyword (reference: MySQL), statement: 5, table: "cc_ip_bot"
2. Column "logged" has been found using 2 different data types in 2 tables: BIGINT(14) in cc_ip_log; VARCHAR(64) in cc_ip_file.
3. Column "username" has been found using 2 different data types in 3 tables: VARCHAR(25) in cc_ip_log, cc_ip_file; VARCHAR(128) in cc_ip_exc.
4. Column "user_ip" has been found using 2 different data types in 2 tables: VARCHAR(8) in cc_ip_log; VARCHAR(15) in cc_ip_file.
5. Column "bb_ip" has been found using 2 different data types in 2 tables: VARCHAR(8) in cc_ip_log; VARCHAR(15) in cc_ip_file.
6. Column "ip" has been found using 2 different data types in 2 tables: VARCHAR(128) in cc_ip_exc; VARCHAR(15) in cc_ip_bot.
|
|
|
|
|
|
| Back to Top |
|
|
| Re: error in easyMOD with Codecrush | |
| Posted: 11/05/2006 10:04 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 4:28 AM
Location: St Pete, FL
|
|
|
|
|
|
You can ignore these Warning errors and complete the MOD install...
|
|
|
|
|
| Back to Top |
|
|
| Re: error in easyMOD with Codecrush | |
| Posted: 11/05/2006 10:18 PM |
|
|
|
|
|
| Caravan |
| Posts |
282 |
| Word Cnt. |
31,380 |
| BDay |
Apr 14 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Nov 01, 2006
Local time: 4:28 AM
Location: Denver, PA
|
|
|
|
|
|
Okay, I ignored those, but got this one next....
| Code:
|
SQL PROCESSING HALTED
An error was encountered while processing the SQL commands. Further SQL processing has been halted. You may choose to complete the MOD installation anyway and perform the SQL commands manually yourself. However, at this point EM cannot guarantee the MOD will work correctly so you are best off seeking support from the Author before continuing further.
The failed line was:
INSERT INTO phpbb_cc_ip_config(config_name,config_value) VALUES('cc_logs_per_page','100');;
SQL ERROR: 1146
Table 'friend12_phpb2.phpbb_cc_ip_config' doesn't exist
|
|
|
|
|
|
| Back to Top |
|
|
| Re: error in easyMOD with Codecrush | |
| Posted: 11/05/2006 10:36 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 4:28 AM
Location: St Pete, FL
|
|
|
|
|
|
Dumb. I would have thought a problem like this would have been corrected a long time ago...
Ok, do this:
OPEN
ccip_easyMOD_install.txt
FIND
| Code:
|
INSERT INTO phpbb_cc_ip_config(config_name, config_value) VALUES ('cc_logs_per_page', '100');
INSERT INTO phpbb_cc_ip_config(config_name, config_value) VALUES ('cc_lookup_url', 'http://www.samspade.org/t/ipwhois?a=');
INSERT INTO phpbb_cc_ip_config(config_name, config_value) VALUES ('cc_file_vars', '/var/backups;1500');
INSERT INTO phpbb_cc_ip_config(config_name, config_value) VALUES ('cc_simple', '0');
INSERT INTO phpbb_cc_ip_config(config_name, config_value) VALUES ('ccip_dateformat', 'Y M d');
INSERT INTO phpbb_cc_ip_config(config_name, config_value) VALUES ('ccip_fulldate', 'H:i:s');
INSERT INTO phpbb_cc_ip_config(config_name, config_value) VALUES ('cc_proxy_ports', '80,2301,3128,6588,8000,8080');
INSERT INTO phpbb_cc_ip_config(config_name, config_value) VALUES ('cc_proxy_url', 'http://codecrush.com/prox.php');
INSERT INTO phpbb_cc_ip_config(config_name, config_value) VALUES ('cc_auto_prune', '0');
INSERT INTO phpbb_cc_ip_config(config_name, config_value) VALUES ('cc_auto_prune_age', '365');
INSERT INTO phpbb_cc_ip_config(config_name, config_value) VALUES ('cc_flag_on', '0');
INSERT INTO phpbb_cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Konqueror', '*.*.*.*', 'Konqueror', 'browser', 'konqueror.gif');
INSERT INTO phpbb_cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('MSIE', '*.*.*.*', 'MS Internet Explorer', 'browser', 'ie.gif');
INSERT INTO phpbb_cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Opera', '*.*.*.*', 'Opera', 'browser', 'opera.gif');
INSERT INTO phpbb_cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Netscape', '*.*.*.*', 'Netscape', 'browser', 'netscape.gif');
INSERT INTO phpbb_cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Firefox', '*.*.*.*', 'Firefox', 'browser', '');
INSERT INTO phpbb_cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Galeon', '*.*.*.*', 'Galeon', 'browser', '');
INSERT INTO phpbb_cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Lynx', '*.*.*.*', 'Lynx', 'browser', 'lynx.gif');
INSERT INTO phpbb_cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Epiphany', '*.*.*.*', 'Epiphany', 'browser', '');
INSERT INTO phpbb_cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('googlebot', '*.*.*.*', 'Googlebot', 'bot', '');
INSERT INTO phpbb_cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('inktomi', '*.*.*.*', 'Inktomi', 'bot', '');
INSERT INTO phpbb_cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('ia_archiver', '*.*.*.*', 'IA Archiver', 'bot', '');
INSERT INTO phpbb_cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('ask jeeves', '*.*.*.*', 'Ask Jeeves', 'bot', '');
INSERT INTO phpbb_cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Windows 95', '*.*.*.*', 'Win 95', 'os', 'windows.gif');
INSERT INTO phpbb_cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Windows 98', '*.*.*.*', 'Win 98', 'os', 'windows.gif');
INSERT INTO phpbb_cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Win98', '*.*.*.*', 'Win 98', 'os', 'windows.gif');
INSERT INTO phpbb_cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Windows NT 5.0', '*.*.*.*', 'Win 2000', 'os', 'windows.gif');
INSERT INTO phpbb_cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Linux', '*.*.*.*', 'Linux', 'os', 'linux.gif');
INSERT INTO phpbb_cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Mac_PowerPC', '*.*.*.*', 'Mac PowerPC', 'os', 'mac.gif');
INSERT INTO phpbb_cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('PPC', '*.*.*.*', 'Mac PowerPC', 'os', 'mac.gif');
INSERT INTO phpbb_cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Windows NT 4.0', '*.*.*.*', 'Win NT4', 'os', 'windows.gif');
INSERT INTO phpbb_cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Windows NT 5.1', '*.*.*.*', 'Win XP', 'os', 'windows.gif');
INSERT INTO phpbb_cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Windows ME', '*.*.*.*', 'Win ME', 'os', 'windows.gif');
INSERT INTO phpbb_cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Windows NT 5.2', '*.*.*.*', 'Win 5.2', 'os', 'windows.gif');
INSERT INTO phpbb_cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Mac OS X', '*.*.*.*', 'Mac OS X', 'os', 'mac.gif');
INSERT INTO phpbb_cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('bsd', '*.*.*.*', 'BSD', 'os', 'bsd.gif');
INSERT INTO phpbb_cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('amiga', '*.*.*.*', 'Amiga', 'os', '');
INSERT INTO phpbb_cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('irix', '*.*.*.*', 'IRIX', 'os', 'irix.gif');
INSERT INTO phpbb_cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('beos', '*.*.*.*', 'BeOS', 'os', 'beos.gif');
INSERT INTO phpbb_cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('AvantGo', '*.*.*.*', 'PalmOS', 'os', '');
INSERT INTO phpbb_cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('hp-ux', '*.*.*.*', 'HP-UX', 'os', '');
INSERT INTO phpbb_cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('aix', '*.*.*.*', 'AIX', 'os', 'aix.gif');
INSERT INTO phpbb_cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('sun%os', '*.*.*.*', 'Sun OS', 'os', 'sun.gif');
INSERT INTO phpbb_cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('os/2', '*.*.*.*', 'OS/2', 'os', 'os2.gif');
|
REPLACE WITH
| Code:
|
INSERT INTO cc_ip_config(config_name, config_value) VALUES ('cc_logs_per_page', '100');
INSERT INTO cc_ip_config(config_name, config_value) VALUES ('cc_lookup_url', 'http://www.samspade.org/t/ipwhois?a=');
INSERT INTO cc_ip_config(config_name, config_value) VALUES ('cc_file_vars', '/var/backups;1500');
INSERT INTO cc_ip_config(config_name, config_value) VALUES ('cc_simple', '0');
INSERT INTO cc_ip_config(config_name, config_value) VALUES ('ccip_dateformat', 'Y M d');
INSERT INTO cc_ip_config(config_name, config_value) VALUES ('ccip_fulldate', 'H:i:s');
INSERT INTO cc_ip_config(config_name, config_value) VALUES ('cc_proxy_ports', '80,2301,3128,6588,8000,8080');
INSERT INTO cc_ip_config(config_name, config_value) VALUES ('cc_proxy_url', 'http://codecrush.com/prox.php');
INSERT INTO cc_ip_config(config_name, config_value) VALUES ('cc_auto_prune', '0');
INSERT INTO cc_ip_config(config_name, config_value) VALUES ('cc_auto_prune_age', '365');
INSERT INTO cc_ip_config(config_name, config_value) VALUES ('cc_flag_on', '0');
INSERT INTO cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Konqueror', '*.*.*.*', 'Konqueror', 'browser', 'konqueror.gif');
INSERT INTO cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('MSIE', '*.*.*.*', 'MS Internet Explorer', 'browser', 'ie.gif');
INSERT INTO cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Opera', '*.*.*.*', 'Opera', 'browser', 'opera.gif');
INSERT INTO cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Netscape', '*.*.*.*', 'Netscape', 'browser', 'netscape.gif');
INSERT INTO cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Firefox', '*.*.*.*', 'Firefox', 'browser', '');
INSERT INTO cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Galeon', '*.*.*.*', 'Galeon', 'browser', '');
INSERT INTO cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Lynx', '*.*.*.*', 'Lynx', 'browser', 'lynx.gif');
INSERT INTO cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Epiphany', '*.*.*.*', 'Epiphany', 'browser', '');
INSERT INTO cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('googlebot', '*.*.*.*', 'Googlebot', 'bot', '');
INSERT INTO cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('inktomi', '*.*.*.*', 'Inktomi', 'bot', '');
INSERT INTO cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('ia_archiver', '*.*.*.*', 'IA Archiver', 'bot', '');
INSERT INTO cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('ask jeeves', '*.*.*.*', 'Ask Jeeves', 'bot', '');
INSERT INTO cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Windows 95', '*.*.*.*', 'Win 95', 'os', 'windows.gif');
INSERT INTO cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Windows 98', '*.*.*.*', 'Win 98', 'os', 'windows.gif');
INSERT INTO cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Win98', '*.*.*.*', 'Win 98', 'os', 'windows.gif');
INSERT INTO cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Windows NT 5.0', '*.*.*.*', 'Win 2000', 'os', 'windows.gif');
INSERT INTO cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Linux', '*.*.*.*', 'Linux', 'os', 'linux.gif');
INSERT INTO cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Mac_PowerPC', '*.*.*.*', 'Mac PowerPC', 'os', 'mac.gif');
INSERT INTO cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('PPC', '*.*.*.*', 'Mac PowerPC', 'os', 'mac.gif');
INSERT INTO cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Windows NT 4.0', '*.*.*.*', 'Win NT4', 'os', 'windows.gif');
INSERT INTO cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Windows NT 5.1', '*.*.*.*', 'Win XP', 'os', 'windows.gif');
INSERT INTO cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Windows ME', '*.*.*.*', 'Win ME', 'os', 'windows.gif');
INSERT INTO cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Windows NT 5.2', '*.*.*.*', 'Win 5.2', 'os', 'windows.gif');
INSERT INTO cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('Mac OS X', '*.*.*.*', 'Mac OS X', 'os', 'mac.gif');
INSERT INTO cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('bsd', '*.*.*.*', 'BSD', 'os', 'bsd.gif');
INSERT INTO cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('amiga', '*.*.*.*', 'Amiga', 'os', '');
INSERT INTO cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('irix', '*.*.*.*', 'IRIX', 'os', 'irix.gif');
INSERT INTO cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('beos', '*.*.*.*', 'BeOS', 'os', 'beos.gif');
INSERT INTO cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('AvantGo', '*.*.*.*', 'PalmOS', 'os', '');
INSERT INTO cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('hp-ux', '*.*.*.*', 'HP-UX', 'os', '');
INSERT INTO cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('aix', '*.*.*.*', 'AIX', 'os', 'aix.gif');
INSERT INTO cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('sun%os', '*.*.*.*', 'Sun OS', 'os', 'sun.gif');
INSERT INTO cc_ip_bot (browser_rev, ip, robot, type, image) VALUES ('os/2', '*.*.*.*', 'OS/2', 'os', 'os2.gif');
|
Save, upload, and try again using EM...
 |
|
|
|
|
| Back to Top |
|
|
| Re: error in easyMOD with Codecrush | |
| Posted: 11/05/2006 10:46 PM |
|
|
|
|
|
| Caravan |
| Posts |
282 |
| Word Cnt. |
31,380 |
| BDay |
Apr 14 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Nov 01, 2006
Local time: 4:28 AM
Location: Denver, PA
|
|
|
|
|
|
| Code:
|
SQL PROCESSING HALTED
An error was encountered while processing the SQL commands. Further SQL processing has been halted. You may choose to complete the MOD installation anyway and perform the SQL commands manually yourself. However, at this point EM cannot guarantee the MOD will work correctly so you are best off seeking support from the Author before continuing further.
The failed line was:
CREATE TABLE cc_ip_config (
config_name VARCHAR(255) NOT NULL DEFAULT '',
config_value VARCHAR(255) NOT NULL DEFAULT '',
config_desc VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (config_name)
);;
SQL ERROR: 1050
Table 'cc_ip_config' already exists
|
|
|
|
|
|
| Back to Top |
|
|
| Re: error in easyMOD with Codecrush | |
| Posted: 11/05/2006 10:59 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 4:28 AM
Location: St Pete, FL
|
|
|
|
|
|
| Quote:
|
SQL ERROR: 1050
Table 'cc_ip_config' already exists
|
This is the key to the problem and what you should do about it. Since EM already successfully created these tables before running into the problem on the INSERT INTO queries, then there is no way to create them again. In SQL, you cannot create duplicate tables, fields (columns), or keyed records. So when attempting to create a duplicate table, you would expect an error like this...
What you should do is go back a page and uncheck all of the CREATE TABLE SQL queries and the INSERT INTO queries for the phpbb_config table, but leave the rest checked. Then let EM run the rest of the queries that were screwed up the first time around...
|
|
|
|
|
| Back to Top |
|
|
| Re: error in easyMOD with Codecrush | |
| Posted: 11/06/2006 9:38 AM |
|
|
|
|
|
| Caravan |
| Posts |
282 |
| Word Cnt. |
31,380 |
| BDay |
Apr 14 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Nov 01, 2006
Local time: 4:28 AM
Location: Denver, PA
|
|
|
|
|
|
Okay, I am pretty sure I understood what your saying. I unchecked all of the CREATE TABLE queries and the first 8 or so INSERT INTO queries that were for the _config table and continued on with the easyMOD install. It seemed as though everything went through okay but when I tried to go back to my forum index I get "Couldn't get IP Log session information"......no error codes, just a white backround and "Couldn't get IP Log session information"
Perhaps I didn't uncheck the right ones? Or maybe this is a sign that it's not the right mod to use. 
This was done on my test board obviously so my live board is just fine.
If I have to do a backup manually I will need your help with how to do that since I can't get to the ACP. |
|
|
|
|
| Back to Top |
|
|
| Re: error in easyMOD with Codecrush | |
| Posted: 11/07/2006 7:07 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 4:28 AM
Location: St Pete, FL
|
|
|
|
|
|
| FTM wrote:
|
|
I unchecked all of the CREATE TABLE queries and the first 8 or so INSERT INTO queries that were for the _config table and continued on with the easyMOD install.
|
There were only 4 INSERT INTO queries for the phpbb_config table. You needed to run the rest for the cc_ip_config table...
Ok, perhaps instead of removing the phpbb_ from the INSERT INTO queries for the Codecrush tables, it would have been easier to add it to the CREATE TABLE queries. I got your board working, but the underlying code was expecting to see the phpbb_ table prefix on the CC tables. So we might as well follow the naming standards used for all other phpBB tables...
So my recommendation would be to Restore the Backups for the CC MOD on the Test board, delete the new CC tables and the new CC phpbb_config records from your Test database, add the phpbb_ prefix to all the CC tables in the CREATE TABLE section of the MOD, then try reinstalling it on your Test baord again. I can help you with this if it seems too confusing...
|
|
|
|
|
| Back to Top |
|
|
  |
| Information | |
|
Calendar
