• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Gesior 0.6.2 - News SQL query problem.

Keram

Member
Joined
Jan 8, 2012
Messages
491
Reaction score
12
Location
DUBLIN
Hello

I have a problem because my latestnewsp.php does not add a table to my database... Table that is not being added when installing the gesior acc is z_news_big

And because this isn't added to my database, the latest news and news archive part of the website doesn't work....
So now I have to add this table manually.

Could someone please fix this latesnews.php script so that all needed tables will be added when installing gesior acc?

Sorry but the script was too long for this post... I had to paste it on pastebin.com...
http://pastebin.com/raw.php?i=cgCFFTgN

I'll be very grateful for that and of course I will rep you. Thank you :)


EDIT:
One person told me to add this query to Database:
SQL:
CREATE TABLE IF NOT EXISTS `z_news_big` (
  `hide_news` tinyint(1) NOT NULL DEFAULT '0',
  `date` INT(11) NOT NULL DEFAULT '0',
  `author` VARCHAR(255) NOT NULL,
  `author_id` INT(11) NOT NULL,
  `image_id` INT(3) NOT NULL DEFAULT '0',
  `topic` VARCHAR(255) NOT NULL,
  `text` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
but it didn't work :(

any ideas? :S
 
Last edited:
Back
Top