Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Topics - dj9live

Pages: [1]
1
Code: [Select]
DB Error: Bad SQL Query: SELECT DISTINCT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, c.cat_name, u.user_name FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND i.cat_id NOT IN (0) AND c.cat_id = i.cat_id ORDER BY RAND() You have an error in your SQL syntax near 'RAND()' at line 5

was kann da denn falsch sein?

2
Mods & Plugins (Requests & Discussions) / Anzeigereihenfolge ändern
« on: June 12, 2003, 03:57:19 PM »
Hi,

in dem Dropdownfeld auf der Hauptseite, wo man direkt die Kategorie auswählen kann ist die Sortierung Standard von CAT_ID von 0 bis aufwärts, Frage: gibt es die möglichkeit das Dropdownfeld quasi genau andersherum füllen zu lassen ???

für nen Tip wäre ich dankbar (schätze da muss der SQL Query geändert werden?)

danke kai

3
Discussion & Troubleshooting / mysql meldet fehler:
« on: June 11, 2003, 05:33:05 PM »
ich habe seit heute folgende Fehlermeldung wenn ich images aufrufe:


Code: [Select]

DB Error: Bad SQL Query: SELECT c.cat_id, c.cat_name, c.cat_description, c.cat_parent_id, c.cat_hits, c.cat_order, c.auth_viewcat, c.auth_viewimage, c.auth_download, c.auth_upload, c.auth_directupload, c.auth_vote, c.auth_sendpostcard, c.auth_readcomment, c.auth_postcomment, COUNT(i.image_id) AS new_images FROM 4images_categories c LEFT JOIN 4images_images i ON (i.cat_id = c.cat_id AND i.image_date >= 1054742944 AND i.image_active = 1) GROUP BY c.cat_id ORDER BY c.cat_order, c.cat_name ASC
Got error 127 from table handler

DB Error: Bad SQL Query: SELECT cat_id, COUNT(*) AS num_images FROM 4images_images WHERE image_active = 1 GROUP BY cat_id
Got error 127 from table handler

DB Error: Bad SQL Query: SELECT u.*, l.* FROM 4images_users u, 4images_lightboxes l WHERE u.user_id = 1 AND l.user_id = u.user_id
Got error 127 from table handler

DB Error: Bad SQL Query: SELECT * FROM 4images_users WHERE user_id = 1
Got error 127 from table handler

Warning: Cannot modify header information - headers already sent by (output started at /home/www/web5/html/foto/includes/db_mysql.php:188) in /home/www/web5/html/foto/includes/sessions.php on line 79

Warning: Cannot modify header information - headers already sent by (output started at /home/www/web5/html/foto/includes/db_mysql.php:188) in /home/www/web5/html/foto/includes/sessions.php on line 79

Warning: Cannot modify header information - headers already sent by (output started at /home/www/web5/html/foto/includes/db_mysql.php:188) in /home/www/web5/html/foto/includes/sessions.php on line 79

DB Error: Bad SQL Query: SELECT DISTINCT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, c.cat_name, u.user_name FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND i.cat_id NOT IN (0) AND c.cat_id = i.cat_id ORDER BY RAND()
Got error 127 from table handler

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, c.cat_name, u.user_name FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND i.cat_id NOT IN (0) AND c.cat_id = i.cat_id ORDER BY i.image_hits DESC , i.image_name ASC LIMIT 1
Got error 127 from table handlerDB Error: Bad SQL Query: SELECT c.cat_id, c.cat_name, c.cat_description, c.cat_parent_id, c.cat_hits, c.cat_order, c.auth_viewcat, c.auth_viewimage, c.auth_download, c.auth_upload, c.auth_directupload, c.auth_vote, c.auth_sendpostcard, c.auth_readcomment, c.auth_postcomment, COUNT(i.image_id) AS new_images FROM 4images_categories c LEFT JOIN 4images_images i ON (i.cat_id = c.cat_id AND i.image_date >= 1054742944 AND i.image_active = 1) GROUP BY c.cat_id ORDER BY c.cat_order, c.cat_name ASC
Got error 127 from table handler

DB Error: Bad SQL Query: SELECT cat_id, COUNT(*) AS num_images FROM 4images_images WHERE image_active = 1 GROUP BY cat_id
Got error 127 from table handler

DB Error: Bad SQL Query: SELECT u.*, l.* FROM 4images_users u, 4images_lightboxes l WHERE u.user_id = 1 AND l.user_id = u.user_id
Got error 127 from table handler

DB Error: Bad SQL Query: SELECT * FROM 4images_users WHERE user_id = 1
Got error 127 from table handler

Warning: Cannot modify header information - headers already sent by (output started at /home/www/web5/html/foto/includes/db_mysql.php:188) in /home/www/web5/html/foto/includes/sessions.php on line 79

Warning: Cannot modify header information - headers already sent by (output started at /home/www/web5/html/foto/includes/db_mysql.php:188) in /home/www/web5/html/foto/includes/sessions.php on line 79

Warning: Cannot modify header information - headers already sent by (output started at /home/www/web5/html/foto/includes/db_mysql.php:188) in /home/www/web5/html/foto/includes/sessions.php on line 79

DB Error: Bad SQL Query: SELECT DISTINCT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, c.cat_name, u.user_name FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND i.cat_id NOT IN (0) AND c.cat_id = i.cat_id ORDER BY RAND()
Got error 127 from table handler

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, c.cat_name, u.user_name FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND i.cat_id NOT IN (0) AND c.cat_id = i.cat_id ORDER BY i.image_hits DESC , i.image_name ASC LIMIT 1
Got error 127 from table handler


weiss jemand was passiet sein könnte ?

mfg kai

4
Mods & Plugins (Requests & Discussions) / ip adressen aussperren
« on: December 27, 2002, 01:11:48 PM »
gibt es die möglichkeit durch irgenein kniff eine bestimmte ip-adresse komplett für die gallerie zu sperren ??? wenn ja wie muss ich das machen ???

5
Mods & Plugins (Requests & Discussions) / anpassung
« on: December 10, 2002, 09:51:08 PM »
kleine frage ist es möglich im detail bereich auf eine variabele zuzugreifen in der die URL zum Bild gespeichert ist so das ich z.b. sagen kann
<a href="varBILDURL">Bildlink</a> like this ?!??
es wäre nett wenn ich nen kleines feedback bekommen würde wo und wie ich das am besten einbinde...
danke

6
Ich hab ein dringendes Problem, ich versuche nach neuen Bildern zu checken und bekomme nur die Fehlermeldung Warning:

SAFE MODE Restriction in effect. The script whose uid is 640 is not allowed to access ./../data/media/33 owned by uid 30 in /home/www/web5/html/foto/admin/checkimages.php on line 191

was kann da los sein ?

7
Mods & Plugins (Requests & Discussions) / 4images vs phpnuke
« on: September 26, 2002, 11:25:07 PM »
tachen :)

frage wie binde ich 4images in phpnuke in der art ein das es wie die module in phpnuke angeziegt wird (also quasi innerhalb phpnuke) ? die userverwaltung is ja nicht so wichtig, aber ich find es blöd wenn sich deswegen ein neues fenster mit 4images öffnet... jemand ne idee ???
many thnx
kai

8
Discussion & Troubleshooting / fehler nach update von 1.6.1 auf 1.7
« on: September 04, 2002, 03:52:13 PM »
Hab nach dem Update von 1.6.1 auf 1.7 folgende Bugs in den Einstellungen beim Admin tool, kann jemand helfen?


Upload Einstellungen:
 
Warning: Invalid argument supplied for foreach() in /usr/local/httpd/htdocs/kunden/webx/html/foto/admin/settings.php on line 125
 

Account-Aktivierung per Email:
 
Warning: Invalid argument supplied for foreach() in /usr/local/httpd/htdocs/kunden/webx/html/foto/admin/settings.php on line 136


mfg kai

9
Mods & Plugins (Requests & Discussions) / änderung / ergänzung
« on: August 31, 2002, 02:18:29 PM »
hi moin jan & co

ist es möglich im Control Panel Home den letzten Kommentar (oder die letzten 5) Anzeigen zulassen bzw.  z.b. eine mail benachrichtigung an den admin bei neu geposteten kommentaren zu schicken?

mfg
kai

10
Hallo, ist es möglich in der Übersicht die Bilder per Preload anzuzeigen, damit der Besucher schneller die Bilder angezeigt bekommt?!?!

MfG
Kai

Pages: [1]