 | Re: error in easyMOD with Codecrush |  |
 Posted: 11/07/2006 7:22 AM |
 |
|
|
|
|
| Caravan |
| Posts |
282 |
| Word Cnt. |
31,380 |
| BDay |
Apr 14 |
| Sign |
Aries |
| Sex |
 |
|
|
|
Joined: Nov 01, 2006
Local time: 8:08 AM
Location: Denver, PA
|
|
|
|
|
 |
Thank you very much for your help again Nightrider. As much as I would love to say that makes sense, I am not sure I am going to be able to do what you said. I think I may have gotten in over my head too much with this one. But I will certainly see how far I can get hopefully without screwing things up even more.
I will start with
| Quote:
|
|
Restore the Backups for the CC MOD on the Test board
|
Am I right that all I need to do is take the 4 files in my /public_html/test/admin/mods/cc_ip032/backups directory and overwrite the old ones in their corresponding places in the tes board directory? Is this the correct way to restore them? |
|
|
|
|
| Back to Top |
|
|
| Re: error in easyMOD with Codecrush | |
| Posted: 11/07/2006 7:33 AM |
|
|
|
|
|
| Caravan |
| Posts |
282 |
| Word Cnt. |
31,380 |
| BDay |
Apr 14 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Nov 01, 2006
Local time: 8:08 AM
Location: Denver, PA
|
|
|
|
|
|
| Quote:
|
|
delete the new CC tables and the new CC phpbb_config records from your Test database
|
Okay, I think that I can do this. I was affraid I wouldn't know which ones to delete but I am comparing the info to my live board in phpmyadmin and I can see which ones I have on the test board that need to be deleted.
I will try to get this taken care of when I get back from dropping my daughter off at school. |
|
|
|
|
| Back to Top |
|
|
| Re: error in easyMOD with Codecrush | |
| Posted: 11/07/2006 8:00 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
 |
|
|
|
Joined: Sep 25, 2004
Local time: 8:08 AM
Location: St Pete, FL
|
|
|
|
|
|
| FTM wrote:
|
|
Am I right that all I need to do is take the 4 files in my /public_html/test/admin/mods/cc_ip032/backups directory and overwrite the old ones in their corresponding places in the tes board directory? Is this the correct way to restore them?
|
No, just go into EM History and Restore the EM Backups there...
- Restoring EM Backups
If a MOD that you installed with EM hosed your board or you decide that you just don't want it, simply go into EM History in your ACP MOD Center and click on the Details button next to the MOD entry..
On the bottom of the next page, select Restore Backups and press the Go button. Make sure you DON'T select the Remove Record option or you will be forced to manually rolll back the EM backups that were created for you. I will have to walk you through that if need be...
Next you will see a page to confirm eht operation. You would choose Yes:
MODs can only be uninstalled in reverse order that they were installed: FILO (First In, Last Out). So if you installed a MOD, then several others, then decided to remove the first one, you would have to Restore the backups of the other MODs before you could Restore the backups on the first MOD...
It might just be easier to remove phpbb_ from the phpbb_config INSERT INTO query. That's probably the best way to handle this instead of the confusing method I mentioned on the previous page. So you can do this:
OPEN
ccip_easyMOD_install.txt
FIND
| Code:
|
|
INSERT INTO phpbb_config(config_name, config_value) VALUES ('cc_log_prefix', 'phpbb_');
|
REPLACE WITH
| Code:
|
|
INSERT INTO phpbb_config(config_name, config_value) VALUES ('cc_log_prefix', '');
|
Then it should install cleanly with what you used before...
 |
|
|
|
|
| Back to Top |
|
|
| Re: error in easyMOD with Codecrush | |
| Posted: 11/07/2006 11:03 AM |
|
|
|
|
|
| Caravan |
| Posts |
282 |
| Word Cnt. |
31,380 |
| BDay |
Apr 14 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Nov 01, 2006
Local time: 8:08 AM
Location: Denver, PA
|
|
|
|
|
|
Okay, I did restore backups in EM History.
Then when looking for what you told me to edit, I realized it wasn't there. In fact the first 4 SQL inqueries aren't there, which would explain why I got your last directions wrong. So in short....these 4 INSERT INTO SQL lines were taken out on accident and I ran the install without them.
| Code:
|
INSERT INTO phpbb_config(config_name, config_value) VALUES ('cc_log_on', '1');
INSERT INTO phpbb_config(config_name, config_value) VALUES ('cc_log_anon_on', '1');
INSERT INTO phpbb_config(config_name, config_value) VALUES ('cc_log_prefix', 'phpbb_');
INSERT INTO phpbb_config(config_name, config_value) VALUES ('cc_log_time', '60');
|
So I am not going to go any further yet because I don't want to mess it up even more.
Here is the original ccip_easyMOD_install.txt before we did any changes. (just the INSERT INTO section)
| Code:
|
INSERT INTO phpbb_config(config_name, config_value) VALUES ('cc_log_on', '1');
INSERT INTO phpbb_config(config_name, config_value) VALUES ('cc_log_anon_on', '1');
INSERT INTO phpbb_config(config_name, config_value) VALUES ('cc_log_prefix', 'phpbb_');
INSERT INTO phpbb_config(config_name, config_value) VALUES ('cc_log_time', '60');
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');
|
and modified one I used (with the missing SQL queries)
| 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');
|
If I fix my first mistake (put the 4 back in that I took out by accident) is your last suggestion still neccessary? If so the new install file would look like this.
| Code:
|
INSERT INTO phpbb_config(config_name, config_value) VALUES ('cc_log_on', '1');
INSERT INTO phpbb_config(config_name, config_value) VALUES ('cc_log_anon_on', '1');
INSERT INTO phpbb_config(config_name, config_value) VALUES ('cc_log_prefix', '');
INSERT INTO phpbb_config(config_name, config_value) VALUES ('cc_log_time', '60');
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');
|
Since it is apparent I have completely messed it up, would it be better to go ahead and delete the ones I already created (via myphpadmin) and just start over with the EM install?
Here are some screen shots so you can see which ones I did create through my bad copy and paste job.
 |
|
|
|
|
| Back to Top |
|
|
| Re: error in easyMOD with Codecrush | |
| Posted: 11/07/2006 11:36 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 8:08 AM
Location: St Pete, FL
|
|
|
|
|
|
Yes, you can go ahead and delete all of the cc_ tables from your database. Then you will want to delete all the cc_ records from the phpbb_config table too...
The new SQL section should look like this when you are done...
| Code:
|
#
#-----[ SQL ]------------------------------------------
#
CREATE TABLE phpbb_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 phpbb_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 phpbb_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 phpbb_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 phpbb_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 phpbb_cc_ip_sessions (
md5_sum char(32) NOT NULL default '',
session_start BIGINT(14),
primary key(md5_sum)
);
INSERT INTO phpbb_config(config_name, config_value) VALUES ('cc_log_on', '1');
INSERT INTO phpbb_config(config_name, config_value) VALUES ('cc_log_anon_on', '1');
INSERT INTO phpbb_config(config_name, config_value) VALUES ('cc_log_prefix', 'phpbb_');
INSERT INTO phpbb_config(config_name, config_value) VALUES ('cc_log_time', '60');
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');
|
|
|
|
|
|
| Back to Top |
|
|
| Re: error in easyMOD with Codecrush | |
| Posted: 11/07/2006 2:16 PM |
|
|
|
|
|
| Caravan |
| Posts |
282 |
| Word Cnt. |
31,380 |
| BDay |
Apr 14 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Nov 01, 2006
Local time: 8:08 AM
Location: Denver, PA
|
|
|
|
|
|
Thank you Nightrider
I was able to do what you said and it all worked!! Phew, that one scared me a little bit, lol. But it was a great learning experience, it helped me understand the SQL's and what they are actually doing, so that's good!
Now to get it on my live board. For some reason my live board won't backup for me right now (no error, just get blank screen and no backup) so I am going to try in a little bit once I am sure I have my full backup. |
|
|
|
|
| Back to Top |
|
|
| Re: error in easyMOD with Codecrush | |
| Posted: 11/07/2006 5:31 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 8:08 AM
Location: St Pete, FL
|
|
|
|
|
|
Now that all the kinks have been ironed out on the Test board, this MOD should install easily on your Live baord...
For the db backup problem, it would be nice if you got an error message rather than a blank screen so it would give some hint where to look...
 |
|
|
|
|
| Back to Top |
|
|
| Re: error in easyMOD with Codecrush | |
| Posted: 11/07/2006 5:46 PM |
|
|
|
|
|
| Caravan |
| Posts |
282 |
| Word Cnt. |
31,380 |
| BDay |
Apr 14 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Nov 01, 2006
Local time: 8:08 AM
Location: Denver, PA
|
|
|
|
|
|
I know, it was frusterating me! I got tired of waiting so I restarted my computer hoping it would help and it did. I tried the backup and it seemed like it took forever to load and as soon as I thought it was ready to give me the blank screen again it worked. So thanks to your modifications the MOD installed perfectly on my live board. Thank you, you made my day!  |
|
|
|
|
| Back to Top |
|
|
| Re: error in easyMOD with Codecrush | |
| Posted: 11/07/2006 10:49 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 8:08 AM
Location: St Pete, FL
|
|
|
|
|
|
Yahoooo!!! I love success stories. Congratulations Sarah!!!
 |
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Calendar
