Code: Selecteer alles
SELECT * FROM phpbb_gallery WHERE parent_id = 0 ORDER BY left_id ASC LIMIT 50Code: Selecteer alles
SQL ERROR [ mysql4 ]
Field 'gallery_desc' doesn't have a default value [1364]
SQL
INSERT INTO phpbb_gallery (gallery_name) VALUES ('Member Galleries')
Code: Selecteer alles
INSERT INTO phpbb_gallery (gallery_name) VALUES ('Member Galleries')
Algemene foutsan68 schreef:hoi het is me gelukt het werkt nu http://www.duoapart.nl/honden/gallery.php Alleen de tabbladen weer niet poey hey wat een gedoe krijg nu meldingen weer in SQL snap ff niet wat ik nu weer moet doen?
Code: Selecteer alles
SQL
SELECT * FROM phpbb_gallery_photos WHERE poster_id = 2 AND extension IN () and gallery_id <> 0 ORDER BY filetime DESC LIMIT 18446744073709551615
ElbertF schreef:Wat is de hele foutmelding?
Code: Selecteer alles
Algemene fout
SQL ERROR [ mysql4 ]
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and gallery_id <> 0 ORDER BY filetime DESC LIMIT 18446744073709551' at line 4 [1064]
SQL
SELECT * FROM phpbb_gallery_photos WHERE poster_id = 2 AND extension IN () and gallery_id <> 0 ORDER BY filetime DESC LIMIT 18446744073709551615
BACKTRACE
FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()
FILE: includes/db/mysql.php
LINE: 205
CALL: dbal_mysql->sql_query()
FILE: includes/db/dbal.php
LINE: 153
CALL: dbal_mysql->_sql_query_limit()
FILE: includes/gallery/gallery_main.php
LINE: 244
CALL: dbal->sql_query_limit()
FILE: includes/functions_module.php
LINE: 471
CALL: gallery_main->main()
FILE: gallery.php
LINE: 52
CALL: p_master->load_active()
Blijf deze foutmelding houden ?san68 schreef:ElbertF schreef:Wat is de hele foutmelding?Code: Selecteer alles
Algemene fout SQL ERROR [ mysql4 ] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and gallery_id <> 0 ORDER BY filetime DESC LIMIT 18446744073709551' at line 4 [1064] SQL SELECT * FROM phpbb_gallery_photos WHERE poster_id = 2 AND extension IN () and gallery_id <> 0 ORDER BY filetime DESC LIMIT 18446744073709551615 BACKTRACE FILE: includes/db/mysql.php LINE: 158 CALL: dbal->sql_error() FILE: includes/db/mysql.php LINE: 205 CALL: dbal_mysql->sql_query() FILE: includes/db/dbal.php LINE: 153 CALL: dbal_mysql->_sql_query_limit() FILE: includes/gallery/gallery_main.php LINE: 244 CALL: dbal->sql_query_limit() FILE: includes/functions_module.php LINE: 471 CALL: gallery_main->main() FILE: gallery.php LINE: 52 CALL: p_master->load_active()