Zikula Community

• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 25

  Posted: Feb 06, 2007 - 06:12 PM

  I come here because I cannot find very good documentation for this module and I have posted at their development site with no responses.
  
  I copied the files to their respective directories, everything went smoothly until I tried to initialize the module. Now I am getting the error "Error! Sorry! Table creation failed"
  
  So, I uninstalled the module completely. Reuploaded it to the server and regenerated. Same issue again.
  
  Next thing I did was completely removed it and the Messages module, removed respective database entries, and reuploaded Messages from backup, now I am having same error with Messages module trying to initialize it.
  
  What could be causing this?
  
  Thanks for any help!

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 25

  Posted: Feb 07, 2007 - 04:51 PM

  Ok, actually I have just noticed that I get this error with most modules I try to initialize. A couple will initialize, but the majority of the ones I tested will not.
  
  Is there something wrong with a setting or something thats not allowing these modules to write to the database?
  
  Any help is greatly appreciated!

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Feb 20, 2007
  • Posts: 3

  Posted: Feb 15, 2007 - 04:52 PM

  Check which version of mySQL your server is running, as have been having the same problem on a server running 4.0.27-standard.
  And yes, some big hosting companies still have boxes like this!
  
  The only way I have found around this is to find a box with a more modern version and then export the SQL tables............
  
  
  
  edited by: daggon, Feb 16, 2007 - 04:58 AM

  • 
  •  
• pnDev
  
  

  • Rank: Softmore
  • Registered: Jul 16, 2004
  • Last visit: Oct 21, 2009
  • Posts: 406

  Posted: Feb 15, 2007 - 06:55 PM

  pnMessages works for me!

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Feb 20, 2007
  • Posts: 3

  Posted: Feb 16, 2007 - 03:59 PM

  Quote

  Ok, actually I have just noticed that I get this error with most modules I try to initialize. A couple will initialize, but the majority of the ones I tested will not.

  
  
  The SQL comment was actually referring to this and not pnmessages .
  
  

  Quote

  Next thing I did was completely removed it and the Messages module, removed respective database entries, and reuploaded Messages from backup, now I am having same error with Messages module trying to initialize it.

  
  
  This also gives a hint as had problems doing a fresh 764 install rather than upgrading from a previous version for my site 'testbench', as the table settings might also not be right - globally changed all my existing tables from nuke_ from pn_ as matter of course during the upgrade of the main site and then reimported.
  
  The server I am working with was probably state of the art back in '03, when the site was first built using .726
  I know the guy who built it and what went in there, as we used to swap modules and bits as we found them ..........
  Just bought a new hosting package from another company as want to get back into the swing of things and the first thing I had to do is put a php.ini file in root as the server is running with safe mode on and Fantastico is still serving 762 as they probably haven't got the 764 script for it yet.
  
  and yes, my avatar is supposed to be upside down!
  
  
  
  
  
  edited by: daggon, Feb 17, 2007 - 04:37 AM

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 25

  Posted: Feb 18, 2007 - 02:10 PM

  Yeah my host made me look like a complete moron. A few months ago they upgraded their servers and I made sure I was on the new ones. I double checked my SQL version and it showed to be updated at the time.
  
  A couple days ago I double checked the version and it showed 3. whatever from my old server. I called my host and asked them if they moved my databases back to my old SQL server, and they said they don't run servers with that old of a version anymore. I told the dude that I am looking at the server version in phpMyAdmin right now and its showing 3.x. He looked into it and said "Wow, I didn't realize we still had servers with that version".
  
  Long story short, they moved me quick to new server and all is good now. Thanks for your replies though, greatly appreciated.

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Feb 20, 2007
  • Posts: 3

  Posted: Feb 20, 2007 - 05:19 AM

  Glad they upgraded it properly at last!
  
  

  Quote

  Yeah my host made me look like a complete moron.

  
  
  You are far from being a moron, as there are thousands of postnuke users out there who are going to have this problem, give up, and try a different CMS, rather than nag support, get moved to another server/hosting company and have to use quickswitch and then have the worry of 'did quickswitch actually move everything?', cos although quickswitch is fantastic, there's always that concern.
  
  Perhaps it might be an idea if module creators could add a SQL dump of the new tables to their docs, so that oldsters have a chance of using the new modules - unless someone smart out there has coded a reverse solution to the 'module generator' on Openstar............
  
  This idea is based on 'least common denominator' as NOT everyone is fluent in PHP and SQL and have trouble finding their way around the admin pages!
  
  

  • 
  •  
• bbirney
  
  

  • Rank: Registered User
  • Registered: Apr 23, 2004
  • Last visit: Feb 07, 2010
  • Posts: 30

  Posted: Feb 21, 2007 - 04:42 AM

  Honestly, if your host isn't running decent software, I would think you should switch hosts. Invisible hand of the marketplace and all that. Why stay with a crappy host when there are good, cheap ones?
  
  I send most of my clients to a private hosting service, but every now and then I get one for whom that kind of solution isn't right, and I send them to APlus. They let you switch between PHP 4 and 5 on the fly, though they only run MySQL 4.1.21. Pretty cheap though, and it runs PostNuke fine.
  
  --
  --
  Ben Birney
  http://www.tilsontech.com/
  http://www.sophiasfall.com/

  • 
  •  
•  
•  

Users on-line

• mazdev,
• mesteele101

This list is based on users active over the last 60 minutes.