6
Any Clues to why I can install a basic variation on the tutorial module locally (apache 2.2) and it works fine, but uploading the same tutorial and testing on my server does not.
both XOOPS 2.3.x
server details
XOOPS Version - XOOPS 2.3.2
PHP Version - 5.2.5
MySQL Version - 5.0.67.d7-ourdelta-log
Server API Version - cgi-fcgi
OS Version - WINNT
im thinking it is a problem with the sql code, as it seemed different, i removed commas from around the table and field names to be consistent with the tutorials example, but when i try to load it online, after clicking the install module button it takes me back to the module page of XOOPS admin.
CREATE TABLE tutorial_myform (
tt_id int(5) unsigned NOT NULL auto_increment,
namesql varchar(30) NOT NULL default '',
addresssql varchar(30) NOT NULL default '',
telephonesql varchar(30) NOT NULL default '',
emailsql varchar(30) NOT NULL default '',
PRIMARY KEY (tt_id),
KEY name (namesql)
) TYPE=MyISAM;
CREATE TABLE venueuser (
userID tinyint(4) NOT NULL auto_increment,
userEmail varchar(80) NOT NULL,
userRef varchar(16) NOT NULL,
userPassword varchar(28) NOT NULL,
PRIMARY KEY (userID),
UNIQUE KEY userEmail (userEmail, userRef)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
you will see the first half is from the tutorial with the sql added to the names.
thanks
steve
XOOPS Version - XOOPS 2.3.2
PHP Version - 5.2.6
MySQL Version - 5.0.67-community
Server API Version - apache2handler
OS Version - WINNT