I am getting this error after I type in the data in form and I click on the save icon. I am using the standard scriptcase form 4.0
not callable
The user and password is setup correctly and it has the proper permissions to read and write to the mysql database.
The link to it:
http://68.106.145.84/scriptcase/app/BBSLIST/BBSTYPE/BBSTYPE.php
USE BBSLIST;
– MySQL dump 10.11
– Host: localhost Database: BBSLIST
– Server version 5.0.51a-24
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /;
/!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /;
/!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /;
/!40101 SET NAMES utf8 /;
/!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE /;
/!40103 SET TIME_ZONE=’+00:00’ /;
/!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 /;
/!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 /;
/!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=‘NO_AUTO_VALUE_ON_ZERO’ /;
/!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
–
– Current Database: BBSLIST
CREATE DATABASE /!32312 IF NOT EXISTS/ BBSLIST
/*!40100 DEFAULT CHARACTER SET latin1 */;
USE BBSLIST
;
–
– Table structure for table BBSLIST
DROP TABLE IF EXISTS BBSLIST
;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE BBSLIST
(
UN
char(46) NOT NULL COMMENT ‘User Name’,
BN
char(45) NOT NULL COMMENT ‘BBS Name’,
Sysop
char(45) NOT NULL COMMENT ‘Sysop Name’,
Nodes
char(3) NOT NULL COMMENT ‘Nodes’,
BTYPE
char(3) NOT NULL COMMENT ‘BBS Type’,
BBSADR
char(45) NOT NULL COMMENT 'BBS Telnet Address
',
BBSPORT
char(4) NOT NULL COMMENT ‘BBS Port’,
BBSLOC
char(28) NOT NULL COMMENT ‘Location of the bbs’,
USERCOM
longtext NOT NULL COMMENT ‘User Comment’,
MYCOM
longtext NOT NULL COMMENT ‘My Commment’,
RS
char(5) NOT NULL COMMENT ‘Record Status UP/DOWN/DEL or SUP’,
VA
INTEGER NOT NULL COMMENT ‘Verification Attempts’,
LA
char(10) NOT NULL COMMENT ‘Last attempt verification’,
RA
char(10) NOT NULL COMMENT ‘Record Added’,
LU
char(10) NOT NULL COMMENT ‘Last Updated’,
PRIMARY KEY (BN
)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
–
– Dumping data for table BBSLIST
LOCK TABLES BBSLIST
WRITE;
/*!40000 ALTER TABLE BBSLIST
DISABLE KEYS /;
/!40000 ALTER TABLE BBSLIST
ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS HISTORY
;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE HISTORY
(
RN
DOUBLE NOT NULL COMMENT ‘Record Number’,
BN
char(45) NOT NULL COMMENT ‘BBS Name’,
DS
char(25) NOT NULL COMMENT ‘Date Stamp’,
VS
char(25) NOT NULL COMMENT ‘Status of Verification Attempts’,
PRIMARY KEY (RN
)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT=‘Holds all the user information’;
SET character_set_client = @saved_cs_client;
DROP TABLE IF EXISTS BBSTYPE
;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE BBSTYPE
(
BS
char(3) NOT NULL COMMENT ‘BBSTYPE’,
RS
char(2) NOT NULL COMMENT ‘Record Status’,
PRIMARY KEY (BS
)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT=‘Holds all the user information’;
SET character_set_client = @saved_cs_client;
–
– Table structure for table USERS
DROP TABLE IF EXISTS USERS
;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE USERS
(
UN
char(46) NOT NULL,
RN
char(46) NOT NULL COMMENT ‘Real Name’,
AL
char(5) NOT NULL COMMENT ‘Access Admin/User/DEL/SUSP or NEW’,
PW
char(25) NOT NULL COMMENT ‘Password’,
EMAIL
char(60) NOT NULL COMMENT ‘Email Address’,
MYCOM
longtext NOT NULL COMMENT ‘My Commment’,
RS
char(5) NOT NULL COMMENT ‘Record Status UP/DOWN/DEL or SUP’,
RA
char(10) NOT NULL COMMENT ‘Record Added’,
LU
char(10) NOT NULL COMMENT ‘Last Updated’,
PRIMARY KEY (UN
)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT=‘Holds all the user information’;
SET character_set_client = @saved_cs_client;
–
– Dumping data for table USERS
LOCK TABLES USERS
WRITE;
/*!40000 ALTER TABLE USERS
DISABLE KEYS /;
/!40000 ALTER TABLE USERS
ENABLE KEYS /;
UNLOCK TABLES;
/!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE /;
/!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS /;
/!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS /;
/!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /;
/!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /;
/!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION /;
/!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
– Dump completed on 2010-06-21 23:12:31