Zikula Community

• **unknown user**
  
  

  • Rank: Freshman
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 82

  Posted: Aug 13, 2003 - 01:19 AM

  Hi guys,
  
  Just wanted to hear if anyone has tried FormExpress in PN726? I seem to have a problem, which I don't have with any other module, so I'm thinking FormExpress bug - just wanted to confirm that.
  
  My problem is that I can't see what my existing forms and I can't create new ones - I get this message when trying:
  failed-in-danish-langINSERT INTO ( , , , , , , , , , , ) VALUES ( 0 , 'test' , 'adfads' , '{FormExpress:sendmail&email_address=>\'MineButik@EnableIT.dk\'}' , '{FormExpress:display_message&type=\'success\'&message=\'Your message has been sent\'}' , '{FormExpress:display_message&type=\'failure\'&message=\'Ooops! Something horrid has happened!\'}' , '' , '' , '' , '' , '1060779994' )
  
  I also tried to delete the module - I couldn't - had to manually delete the 3 formexpress tables and remove it from nuke_modules table.
  
  Then when trying to initialize it - it fails:
  
  Table creation failedCREATE TABLE ( int(10) NOT NULL auto_increment , varchar(50) NOT NULL , text , text , text , text , text , text , tinyint(4) NOT NULL default 0 , varchar(30) NOT NULL , varchar(30) NOT NULL , PRIMARY KEY( fx_form_id ) )
  
  Something is horribly wrong with this module and PN726 - I tried to delete and re-initialize and activate several other modules, they all work great (incl. Quotes - which also has a pninit.php file).
  
  I'm really lost here - anyone have any idea what could be up? I really depend on this module :(

  • 
  •  
• **unknown user**
  
  

  • Rank: Freshman
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 82

  Posted: Aug 13, 2003 - 06:38 AM

  I got a friend to try FormExpress on a fresh PN726 installation and it works fine for him. I then tried to install a fresh PN726 - but have the same problem.
  
  It seems it's the database (mysql-4.0.13) that doesn't like this syntax:
  
  CREATE TABLE ( int(10) NOT NULL auto_increment , varchar(50) NOT NULL , text , text , text , text , text , text , tinyint(4) NOT NULL default 0 , varchar(30) NOT NULL , varchar(30) NOT NULL , PRIMARY KEY( fx_form_id ) );
  
  I get this error message:
  ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '( int(10) NOT NULL auto_increment , varchar(50) NOT NULL , text
  
  The weird thing is, that I have used MySQL-4 for a pretty long time so I don't understand why this suddenly happens.
  
  Anybody have any ideas what's up with the MySQL syntax here?

  • 
  •  
• **unknown user**
  
  

  • Rank: Freshman
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 82

  Posted: Aug 13, 2003 - 07:42 AM

  Found the problem - it was a bug in MMCache :( typical.

  • 
  •  
• **unknown user**
  
  

  • Rank: Freshman
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 98

  Posted: Aug 18, 2003 - 04:26 PM

  this is completely unrelated...but klavs, I freakin dig your qoute!
  

  Quote

  Working with Unix is like wrestling a worthy opponent.
  Working with windows is like attacking a small whining child
  who is carrying a .38.

  
  :)

  • 
  •  
• **unknown user**
  
  

  • Rank: Freshman
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 82

  Posted: Aug 18, 2003 - 05:54 PM

  hehe. I'm glad you agree with my taste :) - also I my experience with running a lot of big servers (with 3,5 million pageviews pr. week pr. server - and a lot more in total ;) has taught me that this is really true - you always have to have an image of your windows servers handy - when you patch them, harden them etc. - they sometimes suddenly shoot you in the foot :) - Never happens with Unix.

  • 
  •  
•  
•  

Users on-line

• mazdev

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