Windows Znote AAC OTHire SQL-error.

[SnorkY]

Hello! I downloaded OTHire and the recommended Znote AAC (https://github.com/peonso/ZnoteOTHire) and i replaced the layout with Peonso's layout (https://mega.nz/#!6VFyjTaI!YF40GADn_F3xXW1yt4t8w0Rrodxgin7IHTAQBCEC-JY).

I'm getting issues with loading the websites for the forum, houses, guilds and who_is_online. The error messages are shown in the picture. I included parts of mysql tables incase it's helpful. I had these errors before changing layout as well. Anyone knows what might be wrong?

 

[Danger II]

ALTER TABLE houses add `bid` INT UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE houses add `bid_end` INT UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE houses add `last_bid` INT UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE houses add `highest_bidder` INT UNSIGNED NOT NULL DEFAULT 0;

ALTER TABLE guilds add `motd` VARCHAR(255) NOT NULL;

CREATE TABLE `server_record` (
  `record` int(11) NOT NULL,
  `timestamp` bigint(20) NOT NULL,
  UNIQUE KEY `record` (`record`,`timestamp`)
)

Are you sure you are using the znote you have posted?
Cause line 999 inside forum.php is no foreach.. can you post your forum.php?
https://github.com/peonso/ZnoteOTHire/blob/master/www/forum.php#L999

 

[SnorkY]

ALTER TABLE houses add `bid` INT UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE houses add `bid_end` INT UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE houses add `last_bid` INT UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE houses add `highest_bidder` INT UNSIGNED NOT NULL DEFAULT 0;

ALTER TABLE guilds add `motd` VARCHAR(255) NOT NULL;

CREATE TABLE `server_record` (
  `record` int(11) NOT NULL,
  `timestamp` bigint(20) NOT NULL,
  UNIQUE KEY `record` (`record`,`timestamp`)
)

Are you sure you are using the znote you have posted?
Cause line 999 inside forum.php is no foreach.. can you post your forum.php?
https://github.com/peonso/ZnoteOTHire/blob/master/www/forum.php#L999

Now houses, guilds and who is online is working, thanks!

The forum.php is different for the layout i downloaded than the original one i noticied. I tried using the old one but it doesnt work for this layout.

Here's my forum.php file http://www.filedropper.com/forum_4. It's from https://mega.nz/#!6VFyjTaI!YF40GADn_F3xXW1yt4t8w0Rrodxgin7IHTAQBCEC-JY.

I also have this error when i go to localhost/suport.php


Notice: Undefined variable: rankcolor in C:\xampp\htdocs\support.php on line 41

Notice: Undefined variable: rankcolor in C:\xampp\htdocs\support.php on line 41

I really need to improve my sql knowledge. Just for a head start, how did you know that you had to add those lines?

 

[Peonso]

The error messages say what is missing, he is already familiar with the table structure, so he knows how it's built or where to find it.