not callable

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

Re: not callable

It is stored procedure problem related to MySQL? I would look there first.

Regards,
Scott.

Re: not callable

I have the database and within scriptscase that the max amount of charectors allowed for BS is 2 and 1 for RS.

Re: not callable

What are your values for:

BS:
-General Settings / Field Size in Database:
-Values Format / Minimum Size:
-Values Format / Maximum Size:
-Field Size in table

and for RS as well.

Sounds like there is a mismatch somewhere ?? Perhaps in the Min Size?

Regards,
Scott.

Re: not callable

I checked the database and scriptcase setting and all the fields match. I send you a private message with the scriptcase login information.

Re: not callable

I replied to your PM. I was unable to run the app.

Regards,
Scott.