Scheduled Events Add-On

[Rizla]

This is the one I am having problems with. Here is the error I get

MySQL error 1054

Unknown column 'PMEtable0.eventLocation' in 'field list'
phpMyEdit error: invalid SQL query

SELECT `PMEtable0`.`event_id` AS `qf0`,`PMEtable0`.`event_name` AS `qf1`,`PMEtable0`.`eventLocation` AS `qf2`,`PMEtable0`.`event_start` AS `qf3`,`PMEtable0`.`event_stop` AS `qf4`,`PMEtable0`.`event_comment` AS `qf5`,`PMEtable0`.`event_booth_location` AS `qf6`,`PMEtable0`.`special_text` AS `qf7`,`PMEtable0`.`map` AS `qf8` FROM `zen_events` AS `PMEtable0` ORDER BY `PMEtable0`.`event_id` LIMIT 0, 1545.79 miliseconds

Hi
I have just installed this mod and get exactly the same problem... Not upgrading, this is a first time install.

D/B seems ok and all works from admin. This is from the eventz page

What to check next?

[dbltoe]

@BethDog - Sorry. I thought I answered from my iPad, but it doesn't show up here. You should not have an .htaccess file in the eventz directory and I'm wondering why your host is behind on their PHP version. Do you have any debug files in your site's root/cache folder? Any error log items in your cpanel?

@Rizla - BethDog's original problem was caused by an older version of the files. Make sure you are using only the latest version. Since you did not answer the posting tips (server type, PHP/MySQL versions, etc) the only thing I can say at this point is that you "appear" to have the right files and it may be that you have a PHP/MySQL problem.

[Rizla]

Hi
Info: Linux, PHP: 5.2.17, MySQL: 5.0.92

I D/L the mod on the 17th (UK time) I have D/L it today but apears the same exept for a small change in folder size.
Origisnal: 1.3.9h Size: 308kb
Today: 1.3.9h Size: 312kb

If they ARE different (updated) would I have to merge my english.php again? or which file changed?

Or..... do I have a correct one ;)

Host is updating PHP in a couple of days.

Help!

[Rizla]

Checked with Winmerge.... identical, so I seem to have the latest.

Sorry to be a pain... Thinking should I put a support ticket into host?

Rizla

[dbltoe]

Okay, I've either had a senior moment or files got mixed.
The 1054 may be caused by an incorrect file in the eventz folder.
Check around line 147 of the index.php for

$opts['fdd']['eventLocation'] = array(
'name' => 'Event Location',
'select' => 'T',
'maxlen' => 75,
'sort' => true
);

IF that code is there in your version, change it to

$opts['fdd']['event_location'] = array(
'name' => 'Event Location',
'select' => 'T',
'maxlen' => 75,
'sort' => true
);

In other words replace the capital L with _l

This should NOT cause the directory to not appear.

[Rizla]

Arrrrh!! SORTED
God... I must have stared at that for hrs lol

That got rid of the error, Thanks

[Rizla]

Almost..... Just entered data, date format still in US (must have missed something. Data is saving to DB but not displaying on site.

Late here now and off for some sleep. So will look closer in the mornins.

Thanks again

[BethDog]

Voila! That fixed my problem too! But I do have to type in mysite.com/eventz/index.php in order for it to come up. But I thought I would be kind enough to let people know there is a solution if you get the "Page Not Found" error!

[dbltoe]

Language defines are only English for now.

BethDog - if you have to type in the index.php, you have a setting out of whack on the server. Check with your host.

ALL - Looks like some bad files got uploaded. I'll know more later tonight.

[BethDog]

@dbltoe my whole server is out of wack! I'm going to be looking for a new one.