Ayuda con SQL Tema Solucionado
Publicado: 26 May 2010, 15:39
necesito ayuda amigos bueno instale el thanks_first_post_ 0.0.1 y ps amigos no se como instalar el SQL bueno pienso por eso que cuando entro a un tema de mi foro me vota este error
Error General
SQL ERROR [ mysqli ]
Table 'ayacucho_forogsm.phpbb_thanks' doesn't exist [1146]
SQL
SELECT thanks_from FROM phpbb_thanks WHERE post_id = 2346 AND thanks_from = 2
BACKTRACE
FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()
FILE: viewtopic.php
LINE: 1587
CALL: dbal_mysqli->sql_query()
Este de aqui aun no agregue o instale, lo que quiero es instalar pero como lo hago gracias por sus ayudaaass
SQL
Código:Seleccionar Todo
_________________________________________________________________
CREATE TABLE `phpbb_thanks` (
`thanks_id` mediumint(8) unsigned NOT NULL auto_increment,
`thanks_from` mediumint(8) unsigned NOT NULL,
`thanks_to` mediumint(8) unsigned NOT NULL,
`post_id` mediumint(8) unsigned NOT NULL,
PRIMARY KEY (`thanks_id`)
);
ALTER TABLE `phpbb_posts` ADD `post_thanked` INT(11) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_users` ADD `user_thanked` INT(11) UNSIGNED NOT NULL DEFAULT '0',
ADD `user_thanks` INT(11) UNSIGNED NOT NULL DEFAULT '0',
ADD `user_thanks_post` INT(11) UNSIGNED NOT NULL DEFAULT '0';
Error General
SQL ERROR [ mysqli ]
Table 'ayacucho_forogsm.phpbb_thanks' doesn't exist [1146]
SQL
SELECT thanks_from FROM phpbb_thanks WHERE post_id = 2346 AND thanks_from = 2
BACKTRACE
FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()
FILE: viewtopic.php
LINE: 1587
CALL: dbal_mysqli->sql_query()
Este de aqui aun no agregue o instale, lo que quiero es instalar pero como lo hago gracias por sus ayudaaass
SQL
Código:Seleccionar Todo
_________________________________________________________________
CREATE TABLE `phpbb_thanks` (
`thanks_id` mediumint(8) unsigned NOT NULL auto_increment,
`thanks_from` mediumint(8) unsigned NOT NULL,
`thanks_to` mediumint(8) unsigned NOT NULL,
`post_id` mediumint(8) unsigned NOT NULL,
PRIMARY KEY (`thanks_id`)
);
ALTER TABLE `phpbb_posts` ADD `post_thanked` INT(11) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_users` ADD `user_thanked` INT(11) UNSIGNED NOT NULL DEFAULT '0',
ADD `user_thanks` INT(11) UNSIGNED NOT NULL DEFAULT '0',
ADD `user_thanks_post` INT(11) UNSIGNED NOT NULL DEFAULT '0';