CMS Made Simple Forums

Posted: **Thu Feb 05, 2015 4:42 am**

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.

Posted: **Thu Feb 05, 2015 5:43 am**

Please post system information

Posted: **Thu Feb 05, 2015 5:50 am**

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

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

CMS Made Simple Forums

CGExtensions 1.45 installation cg_sql_error

CGExtensions 1.45 installation cg_sql_error

Re: CGExtensions 1.45 installation cg_sql_error

Re: CGExtensions 1.45 installation cg_sql_error