Problems After Upgrade - Can't Add Events

RudyG · 04-17-2009, 05:22 PM

Recently, PHP and Zend were updated on my server. After the upgrade I was unable to add new events - but could see old ones.

Whenever trying to add a new event the process appeared to go through without any problems or errors - even the script even responded with something like "Database has been uodated". But the new event does not show in the Calendar, nor are there any new entries in the database itself.

I just took the additional step of Upgrading the script to the latest version. Same problem as before - still can't add new events - and I'm not getting any errors...

Help...

**Brian** · 04-17-2009, 05:25 PM

Are you using mySQL? If so, do you have a repeat or repeatx column in the database table?

RudyG · 04-17-2009, 05:29 PM

Brian,

Yes, I'm using MySQL, and yes, I have a field named "repeatx".

-Rudy

**Brian** · 04-17-2009, 05:41 PM

It seems you database did update correctly... Try upload all of the files in the events directory again. You may have an issue with one or more of them.

RudyG · 04-17-2009, 05:46 PM

Brian,

I uploaded the event directory. Still not working.

-Rudy

ve9gra · 04-17-2009, 07:15 PM

He didn't specify, but make sure that you upload those files in forced Binary mode. Using anythign else will break the encryption and render them useless.

RudyG · 04-17-2009, 08:01 PM

Quote:

Originally Posted by ve9gra

He didn't specify, but make sure that you upload those files in forced Binary mode. Using anythign else will break the encryption and render them useless.

Thanks for the reply. Tried that, no help.

Please correct me if I'm wrong, but it seems that if the file upload type corrupted the Event files, then the script would not function at all. The script appears to function, but the event does not get inserted into the database... No errors...

**Brian** · 04-17-2009, 11:37 PM

Can you open a support ticket and attach a dump of your database?

RudyG · 04-18-2009, 09:19 AM

Brian,

I've solved the problem by doing a complete, clean reinstall of your script - including the database structure.

When I first encountered this problem, I did a complete reinstall using your "auto installer", BUT I kept using the existing database. The problem persisted... This obviously points to a problem with the database.

Here is my opinion on what caused this... A few months ago, I moved that site to a new server using the Plesk Migration tool. I've noticed problems with databases after migration using Plesk. I've been doing dumps and recreating databases manually on the new server to resolve this. It's probable I skipped this step with this web site's database... And since the client has rarely used the site, or added many events, the problem did not become evident until an unrelated Zend issue caused the client to notice the calendar was not working...

I will open a support ticket and send you the bad database - in case it will help someone else in the future, but my problem is solved and does not require additional support.

Thank you for your prompt responses...

-Rudy