mysqli - MySQLi 1146 Error? - Udvikleren.dk - Programmering, webdesign og grafik

Tags: mysqli 1146 error

<< < 1 2 > >>

Bruger #15611 @ 28.07.12 00:08

Hej.

Har installeret phpBB3 og valgt at installere 2 plugins, det ene et donate, det andet et galleri.

Donate virker som det skal, men, det gør galleri pluginet ikke..

Har sådan egentligt gjort som jeg blev bedt om igennem vejledningen men kan ikke fremskaffe den manglede tabel, som erroren melder om.

SQL ERROR [ mysqli ]

Table 'phpbb_gallery_users' doesn't exist [1146]

Hvad gør jeg forkert?

17 svar postet i denne tråd vises herunder
0 indlæg har modtaget i alt 0 karma

Sorter efter stemmer Sorter efter dato

Bruger #17260 @ 28.07.12 00:23

108

Der følger sikkert en sql fil med. Du mangler i hvert fald at indsætte tabellen

Bruger #955 @ 28.07.12 00:36

1.624

Google aflører det er et hyppigt problem ved phpBB3 installationen. En eller flere tabeller bliver ikke oprettet, og typisk skyldes det at det er blevet installeret gennem cpanel.

Er dette ikke tilfældet, så download installationsfilerne igen. Du må kunne finde tabel definitionen der imellem og oprette den manuelt.

Bruger #15611 @ 28.07.12 01:40

Nicklas: Det er såment gået op for mig

Stefan: Jeg har manuelt installeret den phpMOD, som beskrevet i installationen, tabellen kan jeg dog ikke finde nogen steder...

Bruger #17260 @ 28.07.12 01:48

108

Beklager, var helt opslugt af OL.

Har et mulighed for at linke til de filer du har? kender ikke til phpbb, men tabellen burde vel være at finde

Bruger #15611 @ 28.07.12 01:57

Det skulle meget gerne være herfra jeg fandt downloaden/filerne, samt vejledningen osv.

http://www.phpbb.com/community/viewtopic.php?t=1825475

Bruger #17260 @ 28.07.12 04:52

108

PHP kode

 <?php
 /**
 *
 * @package phpBB Gallery
 * @version $Id$
 * @copyright (c) 2011 nickvergessen nickvergessen@gmx.de http://www.flying-bits.org
 * @license http://opensource.org/licenses/gpl-license.php GNU Public License
 *
 */
 
 if (!defined('IN_PHPBB'))
 {
     exit;
 }
 if (!defined('IN_INSTALL'))
 {
     exit;
 }
 
 class phpbb_gallery_dbal_schema
 {
     static public function get_table_data($table)
     {
         return self::$data[$table]['structure'];
     }
 
     /**
     * Column Types:
     *    INT:x        => SIGNED int(x)
     *    BINT        => BIGINT
     *    UINT        => mediumint(8) UNSIGNED
     *    UINT:x        => int(x) UNSIGNED
     *    TINT:x        => tinyint(x)
     *    USINT        => smallint(4) UNSIGNED (for _order columns)
     *    BOOL        => tinyint(1) UNSIGNED
     *    VCHAR        => varchar(255)
     *    CHAR:x        => char(x)
     *    XSTEXT_UNI    => text for storing 100 characters (topic_title for example)
     *    STEXT_UNI    => text for storing 255 characters (normal input field with a max of 255 single-byte chars) - same as VCHAR_UNI
     *    TEXT_UNI    => text for storing 3000 characters (short text, descriptions, comments, etc.)
     *    MTEXT_UNI    => mediumtext (post text, large text)
     *    VCHAR:x        => varchar(x)
     *    TIMESTAMP    => int(11) UNSIGNED
     *    DECIMAL        => decimal number (5,2)
     *    DECIMAL:    => decimal number (x,2)
     *    PDECIMAL    => precision decimal number (6,3)
     *    PDECIMAL:    => precision decimal number (x,3)
     *    VCHAR_UNI    => varchar(255) BINARY
     *    VCHAR_CI    => varchar_ci for postgresql, others VCHAR
     */
     static private $data = array(
         'albums'    => array(
             'full_name'        => GALLERY_ALBUMS_TABLE,
             'added'            => '0.0.0',
             'modified'        => '1.1.0',
             'structure'        => array(
                 'COLUMNS'        => array(
                     'album_id'                    => array('UINT', NULL, 'auto_increment'),
                     'parent_id'                    => array('UINT', 0),
                     'left_id'                    => array('UINT', 1),
                     'right_id'                    => array('UINT', 2),
                     'album_parents'                => array('MTEXT_UNI', ''),
                     'album_type'                => array('UINT:3', 1),
                     'album_status'                => array('UINT:1', 1),
                     'album_contest'                => array('UINT', 0),
                     'album_name'                => array('VCHAR:255', ''),
                     'album_desc'                => array('MTEXT_UNI', ''),
                     'album_desc_options'        => array('UINT:3', 7),
                     'album_desc_uid'            => array('VCHAR:8', ''),
                     'album_desc_bitfield'        => array('VCHAR:255', ''),
                     'album_user_id'                => array('UINT', 0),
                     'album_images'                => array('UINT', 0),
                     'album_images_real'            => array('UINT', 0),
                     'album_last_image_id'        => array('UINT', 0),
                     'album_image'                => array('VCHAR', ''),
                     'album_last_image_time'        => array('INT:11', 0),
                     'album_last_image_name'        => array('VCHAR', ''),
                     'album_last_username'        => array('VCHAR', ''),
                     'album_last_user_colour'    => array('VCHAR:6', ''),
                     'album_last_user_id'        => array('UINT', 0),
                     'album_watermark'            => array('UINT:1', 1),
                     'album_sort_key'            => array('VCHAR:8', ''),
                     'album_sort_dir'            => array('VCHAR:8', ''),
                     'display_in_rrc'            => array('UINT:1', 1),
                     'display_on_index'            => array('UINT:1', 1),
                     'display_subalbum_list'        => array('UINT:1', 1),
                     'album_feed'                => array('BOOL', 1),
                     'album_auth_access'            => array('TINT:1', 0),
                 ),
                 'PRIMARY_KEY'    => 'album_id',
             ),
         ),
         'albums_track'    => array(
             'full_name'        => GALLERY_ATRACK_TABLE,
             'added'            => '0.5.2',
             'modified'        => '0.5.2',
             'structure'        => array(
                 'COLUMNS'        => array(
                     'user_id'                => array('UINT', 0),
                     'album_id'                => array('UINT', 0),
                     'mark_time'                => array('TIMESTAMP', 0),
                 ),
                 'PRIMARY_KEY'    => array('user_id', 'album_id'),
             ),
         ),
         'comments'    => array(
             'full_name'        => GALLERY_COMMENTS_TABLE,
             'added'            => '0.0.0',
             'modified'        => '1.1.1',
             'structure'        => array(
                 'COLUMNS'        => array(
                     'comment_id'            => array('UINT', NULL, 'auto_increment'),
                     'comment_image_id'        => array('UINT', NULL),
                     'comment_user_id'        => array('UINT', 0),
                     'comment_username'        => array('VCHAR', ''),
                     'comment_user_colour'    => array('VCHAR:6', ''),
                     'comment_user_ip'        => array('VCHAR:40', ''),
                     'comment_signature'        => array('BOOL', 0),
                     'comment_time'            => array('UINT:11', 0),
                     'comment'                => array('MTEXT_UNI', ''),
                     'comment_uid'            => array('VCHAR:8', ''),
                     'comment_bitfield'        => array('VCHAR:255', ''),
                     'comment_edit_time'        => array('UINT:11', 0),
                     'comment_edit_count'    => array('USINT', 0),
                     'comment_edit_user_id'    => array('UINT', 0),
                 ),
                 'PRIMARY_KEY'    => 'comment_id',
                 'KEYS'        => array(
                     'id'            => array('INDEX', 'comment_image_id'),
                     'uid'            => array('INDEX', 'comment_user_id'),
                     'ip'            => array('INDEX', 'comment_user_ip'),
                     'time'            => array('INDEX', 'comment_time'),
                 ),
             ),
         ),
         'config'    => array(
             'full_name'        => GALLERY_CONFIG_TABLE,
             'added'            => '0.0.0',
             'modified'        => '0.0.0',
             'structure'        => array(
                 'COLUMNS'        => array(
                     'config_name'        => array('VCHAR:255', ''),
                     'config_value'        => array('VCHAR:255', ''),
                 ),
                 'PRIMARY_KEY'    => 'config_name',
             ),
         ),
         'contests'    => array(
             'full_name'        => GALLERY_CONTESTS_TABLE,
             'added'            => '0.4.1',
             'modified'        => '0.4.1',
             'structure'        => array(
                 'COLUMNS'        => array(
                     'contest_id'            => array('UINT', NULL, 'auto_increment'),
                     'contest_album_id'        => array('UINT', 0),
                     'contest_start'            => array('UINT:11', 0),
                     'contest_rating'        => array('UINT:11', 0),
                     'contest_end'            => array('UINT:11', 0),
                     'contest_marked'        => array('TINT:1', 0),
                     'contest_first'            => array('UINT', 0),
                     'contest_second'        => array('UINT', 0),
                     'contest_third'            => array('UINT', 0),
                 ),
                 'PRIMARY_KEY'    => 'contest_id',
             ),
         ),
         'copyts_albums'    => array(
             'full_name'        => 'phpbb_gallery_copyts_albums',
             'added'            => '0.0.0',
             'modified'        => '0.0.0',
             'structure'        => array(
                 'COLUMNS'        => array(
                     'album_id'                => array('UINT', NULL, 'auto_increment'),
                     'parent_id'                => array('UINT', 0),
                     'left_id'                => array('UINT', 1),
                     'right_id'                => array('UINT', 2),
                     'album_name'            => array('VCHAR:255', ''),
                     'album_desc'            => array('MTEXT_UNI', ''),
                     'album_user_id'            => array('UINT', 0),
                 ),
                 'PRIMARY_KEY'    => 'album_id',
             ),
         ),
         'copyts_users'    => array(
             'full_name'        => 'phpbb_gallery_copyts_users',
             'added'            => '0.0.0',
             'modified'        => '0.0.0',
             'structure'        => array(
                 'COLUMNS'        => array(
                     'user_id'            => array('UINT', 0),
                     'personal_album_id'    => array('UINT', 0),
                 ),
                 'PRIMARY_KEY'        => 'user_id',
             ),
         ),
         'favorites'    => array(
             'full_name'        => GALLERY_FAVORITES_TABLE,
             'added'            => '0.3.1',
             'modified'        => '1.1.1',
             'structure'        => array(
                 'COLUMNS'        => array(
                     'favorite_id'            => array('UINT', NULL, 'auto_increment'),
                     'user_id'                => array('UINT', 0),
                     'image_id'                => array('UINT', 0),
                 ),
                 'PRIMARY_KEY'    => 'favorite_id',
                 'KEYS'        => array(
                     'uid'        => array('INDEX', 'user_id'),
                     'id'        => array('INDEX', 'image_id'),
                 ),
             ),
         ),
         'images'    => array(
             'full_name'        => GALLERY_IMAGES_TABLE,
             'added'            => '0.0.0',
             'modified'        => '1.1.1',
             'structure'        => array(
                 'COLUMNS'        => array(
                     'image_id'                => array('UINT', NULL, 'auto_increment'),
                     'image_filename'        => array('VCHAR:255', ''),
                     'image_name'            => array('VCHAR:255', ''),
                     'image_name_clean'        => array('VCHAR:255', ''),
                     'image_desc'            => array('MTEXT_UNI', ''),
                     'image_desc_uid'        => array('VCHAR:8', ''),
                     'image_desc_bitfield'    => array('VCHAR:255', ''),
                     'image_user_id'            => array('UINT', 0),
                     'image_username'        => array('VCHAR:255', ''),
                     'image_username_clean'    => array('VCHAR:255', ''),
                     'image_user_colour'        => array('VCHAR:6', ''),
                     'image_user_ip'            => array('VCHAR:40', ''),
                     'image_time'            => array('UINT:11', 0),
                     'image_album_id'        => array('UINT', 0),
                     'image_view_count'        => array('UINT:11', 0),
                     'image_status'            => array('UINT:3', 0),
                     'image_contest'            => array('UINT:1', 0),
                     'image_contest_end'        => array('TIMESTAMP', 0),
                     'image_contest_rank'    => array('UINT:3', 0),
                     'image_filemissing'        => array('UINT:3', 0),
                     'image_has_exif'        => array('UINT:3', 2),
                     'image_exif_data'        => array('TEXT', ''),
                     'image_rates'            => array('UINT', 0),
                     'image_rate_points'        => array('UINT', 0),
                     'image_rate_avg'        => array('UINT', 0),
                     'image_comments'        => array('UINT', 0),
                     'image_last_comment'    => array('UINT', 0),
                     'image_allow_comments'    => array('TINT:1', 1),
                     'image_favorited'        => array('UINT', 0),
                     'image_reported'        => array('UINT', 0),
                     'filesize_upload'        => array('UINT:20', 0),
                     'filesize_medium'        => array('UINT:20', 0),
                     'filesize_cache'        => array('UINT:20', 0),
                 ),
                 'PRIMARY_KEY'                => 'image_id',
                 'KEYS'        => array(
                     'aid'            => array('INDEX', 'image_album_id'),
                     'uid'            => array('INDEX', 'image_user_id'),
                     'time'            => array('INDEX', 'image_time'),
                 ),
             ),
         ),
         'modscache'    => array(
             'full_name'        => GALLERY_MODSCACHE_TABLE,
             'added'            => '0.3.1',
             'modified'        => '1.1.1',
             'structure'        => array(
                 'COLUMNS'        => array(
                     'album_id'                => array('UINT', 0),
                     'user_id'                => array('UINT', 0),
                     'username'                => array('VCHAR', ''),
                     'group_id'                => array('UINT', 0),
                     'group_name'            => array('VCHAR', ''),
                     'display_on_index'        => array('TINT:1', 1),
                 ),
                 'KEYS'        => array(
                     'doi'        => array('INDEX', 'display_on_index'),
                     'aid'        => array('INDEX', 'album_id'),
                 ),
             ),
         ),
         'permissions'    => array(
             'full_name'        => GALLERY_PERMISSIONS_TABLE,
             'added'            => '0.3.1',
             'modified'        => '0.4.1',
             'structure'        => array(
                 'COLUMNS'        => array(
                     'perm_id'            => array('UINT', NULL, 'auto_increment'),
                     'perm_role_id'        => array('UINT', 0),
                     'perm_album_id'        => array('UINT', 0),
                     'perm_user_id'        => array('UINT', 0),
                     'perm_group_id'        => array('UINT', 0),
                     'perm_system'        => array('INT:3', 0),
                 ),
                 'PRIMARY_KEY'            => 'perm_id',
             ),
         ),
         'rates'    => array(
             'full_name'        => GALLERY_RATES_TABLE,
             'added'            => '0.0.0',
             'modified'        => '1.1.1',
             'structure'        => array(
                 'COLUMNS'        => array(
                     'rate_image_id'        => array('UINT', 0),
                     'rate_user_id'        => array('UINT', 0),
                     'rate_user_ip'        => array('VCHAR:40', ''),
                     'rate_point'        => array('UINT:3', 0),
                 ),
                 'PRIMARY_KEY'    => array('rate_image_id', 'rate_user_id'),
             ),
         ),
         'reports'    => array(
             'full_name'        => GALLERY_REPORTS_TABLE,
             'added'            => '0.3.1',
             'modified'        => '0.3.1',
             'structure'        => array(
                 'COLUMNS'        => array(
                     'report_id'                => array('UINT', NULL, 'auto_increment'),
                     'report_album_id'        => array('UINT', 0),
                     'report_image_id'        => array('UINT', 0),
                     'reporter_id'            => array('UINT', 0),
                     'report_manager'        => array('UINT', 0),
                     'report_note'            => array('MTEXT_UNI', ''),
                     'report_time'            => array('UINT:11', 0),
                     'report_status'            => array('UINT:3', 0),
                 ),
                 'PRIMARY_KEY'    => 'report_id',
             ),
         ),
         'roles'    => array(
             'full_name'        => GALLERY_ROLES_TABLE,
             'added'            => '0.3.1',
             'modified'        => '1.1.3',
             'structure'        => array(
                 'COLUMNS'        => array(
                     'role_id'            => array('UINT', NULL, 'auto_increment'),
                     'a_list'            => array('UINT:3', 0),
                     'i_view'            => array('UINT:3', 0),
                     'i_watermark'        => array('UINT:3', 0),
                     'i_upload'            => array('UINT:3', 0),
                     'i_edit'            => array('UINT:3', 0),
                     'i_delete'            => array('UINT:3', 0),
                     'i_rate'            => array('UINT:3', 0),
                     'i_approve'            => array('UINT:3', 0),
                     'i_lock'            => array('UINT:3', 0),
                     'i_report'            => array('UINT:3', 0),
                     'i_count'            => array('UINT', 0),
                     'i_unlimited'        => array('UINT:3', 0),
                     'c_read'            => array('UINT:3', 0),
                     'c_post'            => array('UINT:3', 0),
                     'c_edit'            => array('UINT:3', 0),
                     'c_delete'            => array('UINT:3', 0),
                     'm_comments'        => array('UINT:3', 0),
                     'm_delete'            => array('UINT:3', 0),
                     'm_edit'            => array('UINT:3', 0),
                     'm_move'            => array('UINT:3', 0),
                     'm_report'            => array('UINT:3', 0),
                     'm_status'            => array('UINT:3', 0),
                     'a_count'            => array('UINT', 0),
                     'a_unlimited'        => array('UINT:3', 0),
                     'a_restrict'        => array('UINT:3', 0),
                 ),
                 'PRIMARY_KEY'        => 'role_id',
             ),
         ),
         'users'    => array(
             'full_name'        => GALLERY_USERS_TABLE,
             'added'            => '0.3.1',
             'modified'        => '1.1.1',
             'structure'        => array(
                 'COLUMNS'        => array(
                     'user_id'            => array('UINT', 0),
                     'watch_own'            => array('UINT:3', 0),
                     'watch_favo'        => array('UINT:3', 0),
                     'watch_com'            => array('UINT:3', 0),
                     'user_images'        => array('UINT', 0),
                     'personal_album_id'    => array('UINT', 0),
                     'user_lastmark'        => array('TIMESTAMP', 0),
                     'user_last_update'    => array('TIMESTAMP', 0),
                     'user_viewexif'        => array('UINT:1', 0),
                     'user_permissions'    => array('MTEXT_UNI', ''),
                     'user_permissions_changed'    => array('TIMESTAMP', 0),
                     'user_allow_comments'        => array('TINT:1', 1),
                     'subscribe_pegas'            => array('TINT:1', 0),
                 ),
                 'PRIMARY_KEY'        => 'user_id',
                 'KEYS'        => array(
                     'pega'            => array('INDEX', array('personal_album_id')),
                 ),
             ),
         ),
         'watch'    => array(
             'full_name'        => GALLERY_WATCH_TABLE,
             'added'            => '0.3.1',
             'modified'        => '1.1.1',
             'structure'        => array(
                 'COLUMNS'        => array(
                     'watch_id'        => array('UINT', NULL, 'auto_increment'),
                     'album_id'        => array('UINT', 0),
                     'image_id'        => array('UINT', 0),
                     'user_id'        => array('UINT', 0),
                 ),
                 'PRIMARY_KEY'        => 'watch_id',
                 'KEYS'        => array(
                     'uid'            => array('INDEX', 'user_id'),
                     'id'            => array('INDEX', 'image_id'),
                     'aid'            => array('INDEX', 'album_id'),
                 ),
             ),
         ),
     );
 }

Tabellen er her i blandt (users). Kan du ikke selv skrive den om til et clear sql-dump ordner jeg det senere. Er online fra mobilen.

Bruger #15611 @ 28.07.12 15:41

Hej Nicklas.

Du må meget gerne skrive den om til SQL

Mvh. Danni.

Bruger #17260 @ 28.07.12 19:27

108

Hej Danni.

Prøv at kør dette som en sql-forespørgsel.

SQL kode

 CREATE TABLE IF NOT EXISTS `phpbb_gallery_users` (
   `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `watch_own` int(3) unsigned NOT NULL DEFAULT '0',
   `watch_favo` int(3) unsigned NOT NULL DEFAULT '0',
   `watch_com` int(3) unsigned NOT NULL DEFAULT '0',
   `user_images` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `personal_album_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `user_lastmark` int(11) unsigned NOT NULL DEFAULT '0',
   `user_last_update` int(11) unsigned NOT NULL DEFAULT '0',
   `user_viewexif` int(1) unsigned NOT NULL DEFAULT '0',
   `user_permissions` mediumtext NOT NULL DEFAULT '',
   `user_permissions_changed` int(11) unsigned NOT NULL DEFAULT '0',
   `user_allow_comments` int(1) NOT NULL DEFAULT '1',
   `subscribe_pegas` int(1) NOT NULL DEFAULT '0',
   PRIMARY KEY (`user_id`),
   KEY `pega` (`personal_album_id`)
 ) ENGINE=InnoDB;

Bruger #15611 @ 28.07.12 20:07

Hej.

Samme error.
Den brokker sig åbenbart over 2 tabeller.

phpBB_gallery_users
phpBB_gallery_albums

Indlæg senest redigeret d. 28.07.2012 20:11 af Bruger #15611

Bruger #17260 @ 28.07.12 21:30

108

Melder den stadig fejl om users?

<< < 1 2 > >>

MySQLi 1146 Error?

Karma barometer (30 dage)

Modtaget

Givet

Favorit hos
Forum tråde
Artikler