Creating a table on Install
#2
I can't say I know a whole lot about PHP, but I feel as though I know more around SQL as I've done a couple lessons on it in the past. Regardless, I copied your query into PHPMyAdmin and there were some errors.

I'm unfamiliar with 'UNSIGNED', but whatever it is, was the main issue, and I looked up queries that used UNSIGNED and none used it like you did. I edited the query and this worked fine for me(To insert into PHPMyAdmin)

CREATE TABLE mybb_turnorder(
  id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  thread SMALLINT(5) NOT NULL,
  lastPosition TINYINT(2) UNSIGNED DEFAULT 1,
  turn1 VARCHAR(30),
  turn2 VARCHAR(30),
  turn3 VARCHAR(30),
  turn4 VARCHAR(30),
  turn5 VARCHAR(30),
  turn6 VARCHAR(30),
  turn7 VARCHAR(30),
  turn8 VARCHAR(30),
  turn9 VARCHAR(30),
  turn10 VARCHAR(30))
Hopefully someone can confirm, but did you want to try use that query instead and see if it works?
Reply


Messages In This Thread
Creating a table on Install - by Algraud - 2016-11-18, 08:59 PM
RE: Creating a table on Install - by VirtualFrost - 2016-11-19, 11:04 AM
RE: Creating a table on Install - by dragonexpert - 2016-11-19, 02:23 PM
RE: Creating a table on Install - by Algraud - 2016-11-21, 05:27 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)