CGExtensions 1.45 installation cg_sql_error

Have a question or a suggestion about a 3rd party addon module or plugin?
Let us know here.
Post Reply
User avatar
forest-guy
Forum Members
Forum Members
Posts: 32
Joined: Fri Jan 23, 2009 11:10 pm
Location: Albuquerque, New Mexico, USA

CGExtensions 1.45 installation cg_sql_error

Post by forest-guy »

Rebuilding a CMSMS website from scratch using the latest stable version 1.11.12.
When I go to load in CGExtensions 1.45 I get the following fatal error:

Code: Select all

Fatal error: Uncaught cg_sql_error 'Table 'cms_module_cge_countries' already exists -- Table 'cms_module_cge_countries' already exists' in /homepages/3/d320600069/htdocs/modules/CGExtensions/lib/class.cge_utils.php:67 #0 /homepages/3/d320600069/htdocs/lib/adodb_lite/adodbSQL_drivers/mysqli/mysqli_driver.inc(359): cge_utils::{closure}('mysqli', 'EXECUTE', 1050, 'Table 'cms_modu...', 'CREATE TABLE cm...', false, Object(pear_ADOConnection)) #1 /homepages/3/d320600069/htdocs/lib/adodb_lite/adodb.inc.php(316): mysqli_driver_ADOConnection->do_query('CREATE TABLE cm...', -1, -1, false) #2 /homepages/3/d320600069/htdocs/lib/adodb_lite/adodb-datadict.inc.php(329): ADOConnection->Execute('CREATE TABLE cm...') #3 /homepages/3/d320600069/htdocs/modules/CGExtensions/method.install.php(52): ADODB_DataDict->ExecuteSQLArray(Array) #4 /homepages/3/d320600069/htdocs/lib/classes/class.CMSModule.php(1057): include('/homepages/3/d3...') #5 /homepages/3/d320600069/htdocs/lib/classes/class.moduleoperations.inc.php(385): CMSModule->Install() #6 in /homepages/3/d320600069/htdocs/modules/CGExtensions/lib/class.cge_utils.php on line 67
In order to get back into the administrative side I have to delete the modules/CGExtensions folder. I have attempted to go into my database and drop the table cms_module_cge_countries and re-install CGExtensions but get the same error every time. This happens both on my localhost server and on my ISP server.

Any help would be appreciated.

Update: I have CMSMS running on another website and was able to download CGExtensions 1.38.1 from there and put it on this site and it installed just fine.
staartmees
Power Poster
Power Poster
Posts: 1049
Joined: Wed Mar 19, 2008 4:54 pm

Re: CGExtensions 1.45 installation cg_sql_error

Post by staartmees »

Please post system information
User avatar
forest-guy
Forum Members
Forum Members
Posts: 32
Joined: Fri Jan 23, 2009 11:10 pm
Location: Albuquerque, New Mexico, USA

Re: CGExtensions 1.45 installation cg_sql_error

Post by forest-guy »

ISP Server Information
----------------------------------------------

Cms Version: 1.11.12

Installed Modules:

CGSimpleSmarty: 1.7.4
CMSMailer: 5.2.2
CMSPrinting: 1.0.5
FileManager: 1.4.5
MenuManager: 1.8.6
MicroTiny: 1.2.8
ModuleManager: 1.5.8
News: 2.14.4
Search: 1.7.11
ThemeManager: 1.1.8
CGExtensions: 1.38.1
CGCalendar: 1.10.4


Config Information:

php_memory_limit:
process_whole_template:
max_upload_size: 40000000
url_rewriting: none
page_extension:
query_var: page
image_manipulation_prog: GD
auto_alias_content: true
locale:
default_encoding: utf-8
admin_encoding: utf-8
set_names: true


Php Information:

phpversion: 5.5.20
md5_function: On (True)
gd_version: 2
tempnam_function: On (True)
magic_quotes_runtime: Off (False)
E_STRICT: 0
E_DEPRECATED: 0
memory_limit: 120M
max_execution_time: 50000
output_buffering: 0
safe_mode: Off (False)
file_uploads: On (True)
post_max_size: 8M
upload_max_filesize: 40M
session_save_path: /tmp (1777)
session_use_cookies: On (True)
xml_function: On (True)
xmlreader_class: On (True)


Server Information:

Server Api: cgi-fcgi
Server Db Type: MySQL (mysqli)
Server Db Version: 5.1.73
Server Db Grants: Found a "GRANT ALL" statement that appears to be suitable
Server Time Diff: No filesystem time difference found
----------------------------------------------

PC Server Information


----------------------------------------------

Cms Version: 1.11.12

Installed Modules:

CMSMailer: 5.2.2
CMSPrinting: 1.0.5
FileManager: 1.4.5
MenuManager: 1.8.6
MicroTiny: 1.2.8
ModuleManager: 1.5.8
News: 2.14.4
Search: 1.7.11
ThemeManager: 1.1.8
CGSimpleSmarty: 1.7.4
CGExtensions: 1.38.1
CGCalendar: 1.10.4


Config Information:

php_memory_limit:
process_whole_template:
max_upload_size: 2000000
url_rewriting: none
page_extension:
query_var: page
image_manipulation_prog: GD
auto_alias_content: true
locale:
default_encoding: utf-8
admin_encoding: utf-8
set_names: true


Php Information:

phpversion: 5.6.3
md5_function: On (True)
gd_version: 2
tempnam_function: On (True)
magic_quotes_runtime: Off (False)
E_STRICT: 0
E_DEPRECATED: 0
memory_limit: 128M
max_execution_time: 30
output_buffering: 4096
safe_mode: Off (False)
file_uploads: On (True)
post_max_size: 8M
upload_max_filesize: 2M
session_save_path: C:\xampp\tmp (0777)
session_use_cookies: On (True)
xml_function: On (True)
xmlreader_class: On (True)


Server Information:

Server Api: apache2handler
Server Db Type: MySQL (mysqli)
Server Db Version: 5.6.21
Server Db Grants: Found a "GRANT ALL" statement that appears to be suitable
Server Time Diff: No filesystem time difference found


----------------------------------------------
Post Reply

Return to “Modules/Add-Ons”