Database maakt zelf wat?

[Jim]

• Adres van je forum: http://depappa.nl/groep8
  Event. modificaties op je forum: ACP Accountments Centre
  Wanneer ontstond het probleem?Bij het openen van de index
  phpBB versie: 3.0.0
  
  Heb je onlangs iets veranderd aan je forum? Paar MODs
  Wat is het probleem?

MODs installeren gaat steeds goed alleen als er een SQL querrie bij moet komen gaat het fout. Dan krijg ik dit:

SQL ERROR [ mysql4 ]

Table 'vlondergroep8.phpbb_announcement_centre' doesn't exist [1146]

SQL

SELECT * FROM phpbb_announcement_centre

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: includes/functions_announcements.php
LINE: 70
CALL: dbal_mysql->sql_query()

FILE: index.php
LINE: 128
CALL: get_announcement_data()

Wie weet waar dit aan ligt en hoe ik het oplos.

[Salomon]

Je moet de SQL van een mod uitvoeren, dat gebeurd niet automatisch

[Jim]

Ik kan wel een beetje MODs instaleren
Heb ik gedaan, bij 2 verschillende MODs die ik wel op mijn test-forum heb geinstalleert geven nu fouten.

[Niek]

Kun je de sql query die je uit moest voeren hier eens plaatsen?

[Jim]

Ja hoor, ik neem nu als voorbeeld de tweede MOD maar ik had het ook bij de eerste.

Code: Selecteer alles

CREATE TABLE `phpbb_announcement_centre` (
  `announcement_show` tinyint (1) NOT NULL,
  `announcement_enable` tinyint (1) NOT NULL,
  `announcement_enable_guests` tinyint (1) NOT NULL,
  `announcement_show_birthdays` tinyint (1) NOT NULL,
  `announcement_birthday_avatar` tinyint (1) NOT NULL,
  `announcement_draft` text NOT NULL,
  `announcement_text` text NOT NULL,
  `announcement_text_guests` text NOT NULL,
  `announcement_title` varchar(255) NOT NULL default '',
  `announcement_title_guests` varchar(255) NOT NULL default '',
  `announcement_show_group` varchar(255) NOT NULL default '')
  CHARACTER SET utf8 COLLATE utf8_bin;
  

INSERT INTO phpbb_announcement_centre (announcement_show, announcement_enable, announcement_enable_guests, announcement_show_birthdays, announcement_birthday_avatar, announcement_title, announcement_text, announcement_draft, announcement_title_guests, announcement_text_guests, announcement_show_group) VALUES ('0', '1', '1', '0', '0', 'Site Announcements', '[color=red][b]Site Announcements[/b][/color] can be seen here!! :mrgreen:', '[color=red][b]Draft Announcements[/b][/color] can be seen here!! :mrgreen:', 'Guest Announcements', '[color=green][b]Guest Announcements[/b][/color] can be seen here!! :wink:', '2');

[Niek]

Probeer deze query eens.

Code: Selecteer alles

    CREATE TABLE `vlondergroep8.phpbb_announcement_centre` (
      `announcement_show` tinyint (1) NOT NULL,
      `announcement_enable` tinyint (1) NOT NULL,
      `announcement_enable_guests` tinyint (1) NOT NULL,
      `announcement_show_birthdays` tinyint (1) NOT NULL,
      `announcement_birthday_avatar` tinyint (1) NOT NULL,
      `announcement_draft` text NOT NULL,
      `announcement_text` text NOT NULL,
      `announcement_text_guests` text NOT NULL,
      `announcement_title` varchar(255) NOT NULL default '',
      `announcement_title_guests` varchar(255) NOT NULL default '',
      `announcement_show_group` varchar(255) NOT NULL default '')
      CHARACTER SET utf8 COLLATE utf8_bin;
     

    INSERT INTO vlondergroep8.phpbb_announcement_centre (announcement_show, announcement_enable, announcement_enable_guests, announcement_show_birthdays, announcement_birthday_avatar, announcement_title, announcement_text, announcement_draft, announcement_title_guests, announcement_text_guests, announcement_show_group) VALUES ('0', '1', '1', '0', '0', 'Site Announcements', '[color=red][b]Site Announcements[/b][/color] can be seen here!! :mrgreen:', '[color=red][b]Draft Announcements[/b][/color] can be seen here!! :mrgreen:', 'Guest Announcements', '[color=green][b]Guest Announcements[/b][/color] can be seen here!! :wink:', '2');

[Jim]

Dan krijg ik dit

MySQL retourneerde:

#1103 - Incorrect table name 'vlondergroep8.phpbb_announcement_centre'

[Johan]

Code: Selecteer alles

        CREATE TABLE `vlondergroep8.phpbb3_announcement_centre` (
          `announcement_show` tinyint (1) NOT NULL,
          `announcement_enable` tinyint (1) NOT NULL,
          `announcement_enable_guests` tinyint (1) NOT NULL,
          `announcement_show_birthdays` tinyint (1) NOT NULL,
          `announcement_birthday_avatar` tinyint (1) NOT NULL,
          `announcement_draft` text NOT NULL,
          `announcement_text` text NOT NULL,
          `announcement_text_guests` text NOT NULL,
          `announcement_title` varchar(255) NOT NULL default '',
          `announcement_title_guests` varchar(255) NOT NULL default '',
          `announcement_show_group` varchar(255) NOT NULL default '')
          CHARACTER SET utf8 COLLATE utf8_bin;
         

        INSERT INTO vlondergroep8.phpbb3_announcement_centre (announcement_show, announcement_enable, announcement_enable_guests, announcement_show_birthdays, announcement_birthday_avatar, announcement_title, announcement_text, announcement_draft, announcement_title_guests, announcement_text_guests, announcement_show_group) VALUES ('0', '1', '1', '0', '0', 'Site Announcements', '[color=red][b]Site Announcements[/b][/color] can be seen here!! :mrgreen:', '[color=red][b]Draft Announcements[/b][/color] can be seen here!! :mrgreen:', 'Guest Announcements', '[color=green][b]Guest Announcements[/b][/color] can be seen here!! :wink:', '2');

??

[Jim]

Nee, het perfix is in orde.
De database gegevens in config.php stonden verkeert. Dat is ongelost.
Kijk maar op de link. Nu krijg ik weer nieuwe errors

[Johan]

Er werkt een table niet, zijn er niet vergeten SQL-uitvoeringen?

[Jim]

Opgelost, ik gebruikte 2 databases door elkaar
Hoe dom kan je zijn!