If you are using HTMLPad or Rapid CSS, you will have to upgrade to access this feature. Note This feature is available only in WeBuilder and Rapid PHP. When asked, confirm that you want to install the portable version.

Luckily this was not a production database, and even more lucky – the said DB change (change that PK from VARVHAR to BIGINT) would need to run on production within a separate DB instance that can be recreated on deploy. During setup, choose to install the software on your portable drive.

DROP DATABASE dev CREATE DATABASE dev.

but SHOW TABLES still does not list FOO.

DROP TABLE FOO – fail with “cannot delete … foreign key …” Squarespace is the best free website builder to create a professional, sleek, and modern-looking website with minimal effort.

CREATE TABLE FOO ( Id BIGINT) - fail with error 105 – again.

CREATE TABLE FOO ( Id VARCHAR) – success !!.

CREATE TABLE FOO ( Id BIGINT) - fail with error 105.

When doing “SHOW TABLES”, the FOO table was not listed.

We cranked open the mysql console and started to look around: It is inferring the schema from the persisted classes using NHibernate’s mapper and the Schema creation feature of NHibernate. The integration tests runner is dropping all tables and recreating them before running the test suite. However, the table BAR was obsoleted from the schema. There is also a second table in the system (call it BAR) which has a foreign-key into FOO’s primary key.

The schema then changed so that the primary key of FOO became BIGINT. There used to be a table named FOO with a VARCHAR primary key. When creating the database schema during integration tests run, he got “Cannot create table FOO error 105” from MySQL. The weirdest problem happened to a college today.

Webuilder tables