Welcome to Open Discussion

[Nobody/Anonymous]

Welcome to Open Discussion

[Anonymous]

Hello Martin
further to my call for help re weblets.1.2

I found the problem in the database.sql file in the cheques table setup. a follows
# Table structure for table 'cheques'
# lines1 and 5 had a typo  'in' instead of 'int'

CREATE TABLE cheques (
ChequeID int(11) NOT NULL auto_increment,
AccountID int(11) NOT NULL default '0',
IssueDate date NOT NULL default '0000-00-00',
ExpiryDate date NOT NULL default '0000-00-00',
TransactionID int(11) default NULL,
PRIMARY KEY  (ChequeID)
);

#
# Dumping data for table 'cheques'
-------------------------------------------------------
thanks Robert

Hello Martin
I hope you can help me
I am doing a preliminary setup for a new bmt lets website in Byron Bay Australia.

During installation of weblets 1.2 the following error occurred.

----------------------

The system's attempt to set up the structure and initial values in the database has failed. The database server returned the following error message:

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 'in(11) NOT NULL auto_increment, AccountID int(11) NOT NULL
--------------------------------------