Windows Site fourm Error

[melegy]

Hello
i've a problem with my site fourm when any of player click 'thank you' in fourm

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'egxot.thanks' doesn't exist' in C:\xampp\htdocs\forum.php:779 Stack trace: #0 C:\xampp\htdocs\forum.php(779): PDO->query('INSERT INTO `th...') #1 C:\xampp\htdocs\index.php(240): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\forum.php on line 779

any help

regards

 

[melegy]

Up!

 

[Amiroslo]

Base table or view not found: 1146 Table 'egxot.thanks' doesn't exist'

create the table egxot.thanks

 

[Raggaer]

Table thanks is missing on your egxot database

 

[melegy]

how to install it

ALTER TABLE `Egxot.thanks` not null ;

or something like that ?

 

[Raggaer]

I have no idea how the table structure looks like so I cant give you any input... perhaps give us more information

 

[melegy]

It's an icon a player click 'server Website' it in fourms to say thank you to that player

 

[Raggaer]

Show me line 779 of forum.php

 

[melegy]

$SQL->query("INSERT INTO `thanks` (`id` ,`account_id` ,`forum_id` ,`player_name`)VALUES (NULL ,  '$account_id',  'index.php?subtopic=forum&action=show_thread&id=$vthread_id', '$player_name');");

 

[Raggaer]

$SQL->query("INSERT INTO `thanks` (`id` ,`account_id` ,`forum_id` ,`player_name`)VALUES (NULL ,  '$account_id',  'index.php?subtopic=forum&action=show_thread&id=$vthread_id', '$player_name');");

CREATE TABLE thanks (
id INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY, account_id INT(11),
forum_id VARCHAR(255),
player_name VARCHAR(255)
);

Try that query, on mobile and not tested so please confirm