CMS MADE SIMPLE FORGE

EventsListing

 
Back Back to List

[#9414] Module not installing due to PHP/MySQL error

avatar
Created By: Stephan (10010110)
Date Submitted: Mon Jul 22 11:12:14 -0400 2013

Assigned To: Andi Petzoldt (andiministrator)
Version: EventListings 1.6
CMSMS Version: None
Severity: Critical
Resolution: Fixed
State: Closed
Summary:
Module not installing due to PHP/MySQL error
Detailed Description:
Trying to install version 1.6.2 of this module generates the following
notice/error and prevents the module from being installed properly:

>>>>>>>>>>>

Notice: Undefined variable: entry_id in
…/modules/EventsListing/method.install.php on line 55

Notice: Undefined offset: 3 in
…/lib/adodb_lite/adodbSQL_drivers/mysqli/mysqli_driver.inc on line 311
Installation Error:Table 'cms_module_eventslisting_templates' already exists
with(CREATE TABLE cms_module_eventslisting_templates ( entry_id INTEGER NOT NULL
AUTO_INCREMENT, name VARCHAR(255), content TEXT, PRIMARY KEY (entry_id) )ENGINE
MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci)

<<<<<<<<<<<


History

Comments
avatar 
Date: 2013-09-01 05:12
Posted By: Ruud van der Velden (ruudvdvelden)

method.install.php
line 55: $result = $db->Execute($flds, array($entry_id, 'default',
line 79: $result = $db->Execute($flds, array($entry_id, 'hcdefault',

In my opinion both lines should NOT have '$entry_id,' in the query as the table
has an auto incrementing entry_id.

Working:

line 55: $result = $db->Execute($flds, array('default',
line 79: $result = $db->Execute($flds, array('hcdefault',
avatar 
Date: 2014-08-08 06:45
Posted By: john (johnboyuk)

I've just tried installing the latest version of this module that is showing in
the module manager and have the same issue (Installation Error:Table
'cms_module_eventslisting_templates' already exists with...)

My website is now no longer accessible! Any idea how to fix this....
avatar 
Date: 2014-09-20 05:51
Posted By: Christian Karl (networker)

@Ruud: Works super! Thanks! You saved my day!

Christian
avatar 
Date: 2016-02-10 10:18
Posted By: Andi Petzoldt (andiministrator)

Fixed in EventsListibg 2.0.1
Updates

Updated: 2016-02-10 10:18
state: Open => Closed

Updated: 2016-02-10 10:18
resolution_id: 5 => 7
cmsms_version_id: 30123 => -1

Updated: 2013-07-22 11:17
description: Trying to install version 1.6.2 of this module generates the following notice/error and prevents the module from being installed properly: >>>>>>>>>>> Notice: Undefined variable: entry_id in /Users/Stephan/Sites/LMR Sachsen-Anhalt/site/modules/Event => Trying to install version 1.6.2 of this module generates the following notice/error and prevents the module from being installed properly: >>>>>>>>>>> Notice: Undefined variable: entry_id in …/modules/EventsListing/method.install.php on line 55
resolution_id: => 5