SQLite Error when registering about simple-url-shortener HOT 6 CLOSED

What is you DATABASE_TYPE value in the config file ?
The database is created at the install. Can you connect to it and make a show tables; or .tables(if sqlite?).

from simple-url-shortener.

my config values are:
define('DATABASE_TYPE', 'sqlite3'); //mysql or sqlite3
define('SQLITE3_FILE', './database.sqlite3');

There is only one table in the sqlite database: shortener

from simple-url-shortener.

Here the table you should have.
https://github.com/azlux/Simple-URL-Shortener/blob/master/installation.php#L11-L28
If the first table is created, I don't understand why the second is not. Can you check is there are entry missing on the table ?

from simple-url-shortener.

No the Shortener table is created proberly

CREATE TABLE `shortener` (
      `short` char(5) NOT NULL,
      `url` varchar(700) NOT NULL,
      `comment` char(30) DEFAULT NULL,
      `views` int(11) DEFAULT NULL,
      `username` varchar(25) DEFAULT NULL,
      `date` datetime NOT NULL,
      PRIMARY KEY (`short`)
      );

So just to try it out I modified the installation.php and deleted the first table creation. Now the user registration works just fine with only the warning that headers were already been created.

Edit: modified installlation.php as .txt because I cannot upload .php files here
modified_installation.txt

from simple-url-shortener.

good. That is a weird issue you face here.

from simple-url-shortener.

I'm happy with that fix and if I'm the only person confrontated with this I would close the issue now. Thanks for your quick help and time :)

from simple-url-shortener.