Author Topic: 1.6.1 -> 1.7 update problem  (Read 10253 times)

0 Members and 1 Guest are viewing this topic.

Offline AlohaChris

  • Newbie
  • *
  • Posts: 23
    • View Profile
1.6.1 -> 1.7 update problem
« on: September 03, 2002, 09:59:11 AM »
habe soeben auf 1.7 upgedated. das entsprechende update skript funktionierte ("update successfull"), aber nun erscheint auf der index.php seite folgender error:


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, 29, 14, 18, 1, 12, 2, 3, 13, 7, 15, 24, 5, 27, 4, 19, 10, 22, 20, 9, 23, 25, 8, 11, 28, 26, 16, 17) AND c.cat_id = i.cat_id ORDER BY RAND()
You have an error in your SQL syntax near 'RAND()' at line 5


was muss ich tun??

danke!

Offline Jan

  • Administrator
  • 4images Guru
  • *****
  • Posts: 5.024
    • View Profile
    • 4images - Image Gallery Management System
1.6.1 -> 1.7 update problem
« Reply #1 on: September 03, 2002, 10:19:42 AM »
Your first three "must do" before you ask a question:
1. Forum rules
2. FAQ
3. Search

Offline AlohaChris

  • Newbie
  • *
  • Posts: 23
    • View Profile
aber in 1.6.1 ... ?
« Reply #2 on: September 03, 2002, 10:35:46 AM »
schon klar, dass es am random image lag.
danke & sorry ...!

aber, in 1.6.1 hat es mit dem random image geklappt, obwohl die MySQL version gleichgeblieben ist. how come? :?:

Offline Jan

  • Administrator
  • 4images Guru
  • *****
  • Posts: 5.024
    • View Profile
    • 4images - Image Gallery Management System
1.6.1 -> 1.7 update problem
« Reply #3 on: September 03, 2002, 10:42:23 AM »
Nein, das kann nicht sein ;)

Gruß Jan
Your first three "must do" before you ask a question:
1. Forum rules
2. FAQ
3. Search

Offline AlohaChris

  • Newbie
  • *
  • Posts: 23
    • View Profile
doch
« Reply #4 on: September 03, 2002, 11:35:58 AM »
jetzt mal im ernst.
hat es wirklich!

in 1.5 kam dieselbe error message wie jetzt. ich habe dann random image "abgeschaltet". als ich jedoch dann auf 1.6.1 upgedated habe, funktionierte diese funktion ploetzlich. jettz halt, nachdem ich auf 1.7 upgedated habe, nicht mehr.

daher bin ich ja auch verwundert.

Offline AlohaChris

  • Newbie
  • *
  • Posts: 23
    • View Profile
random image
« Reply #5 on: September 15, 2002, 07:01:33 AM »
habe wieder auf 1.6.1 downgegraded. und voila! random image funtzt!  8O

jan, wenn es dich interessiert, kann ich dir die URL schicken.

Offline Jan

  • Administrator
  • 4images Guru
  • *****
  • Posts: 5.024
    • View Profile
    • 4images - Image Gallery Management System
1.6.1 -> 1.7 update problem
« Reply #6 on: September 15, 2002, 09:13:06 AM »
Was steht in Deiner "includes/constants.php"?

Jan
Your first three "must do" before you ask a question:
1. Forum rules
2. FAQ
3. Search

Offline AlohaChris

  • Newbie
  • *
  • Posts: 23
    • View Profile
includes
« Reply #7 on: September 15, 2002, 09:22:33 AM »
Code: [Select]
<?
/**************************************************************************
 *                                                                        *
 *    4images - A Web Based Image Gallery Management System               *
 *    ----------------------------------------------------------------    *
 *                                                                        *
 *             File: constants.php                                        *
 *        Copyright: (C) 2002 Jan Sorgalla                                *
 *            Email: jan@4homepages.de                                    *
 *              Web: http://www.4homepages.de                             *
 *    Scriptversion: 1.6.1                                                *
 *                                                                        *
 *    Never released without support from: Nicky (http://www.nicky.net)   *
 *                                                                        *
 **************************************************************************
 *                                                                        *
 *    Dieses Script ist KEINE Freeware. Bitte lesen Sie die Lizenz-       *
 *    bedingungen (Lizenz.txt) fur weitere Informationen.                 *
 *    ---------------------------------------------------------------     *
 *    This script is NOT freeware! Please read the Copyright Notice       *
 *    (Licence.txt) for further information.                              *
 *                                                                        *
 *************************************************************************/
if (!defined('ROOT_PATH')) {
  die("Security violation");
}

//define('SCRIPT_URL', 'http://your.domain.com/4images'); //no trailing slash
define('SCRIPT_URL', 'http://www.meinedomain.net/4images');

// Table names
define('CATEGORIES_TABLE', $table_prefix.'categories');
define('COMMENTS_TABLE', $table_prefix.'comments');
define('GROUP_ACCESS_TABLE', $table_prefix.'groupaccess');
define('GROUP_MATCH_TABLE', $table_prefix.'groupmatch');
define('GROUPS_TABLE', $table_prefix.'groups');
define('IMAGES_TABLE', $table_prefix.'images');
define('IMAGES_TEMP_TABLE', $table_prefix.'images_temp');
define('LIGHTBOXES_TABLE', $table_prefix.'lightboxes');
define('POSTCARDS_TABLE', $table_prefix.'postcards');
define('SESSIONS_TABLE', $table_prefix.'sessions');
define('SESSIONVARS_TABLE', $table_prefix.'sessionvars');
define('SETTINGS_TABLE', $table_prefix.'settings');
define('USERS_TABLE', $table_prefix.'users');
define('WORDLIST_TABLE', $table_prefix.'wordlist');
define('WORDMATCH_TABLE', $table_prefix.'wordmatch');

// URL PARAMETERS
define('URL_IMAGE_ID', 'image_id');
define('URL_CAT_ID', 'cat_id');
define('URL_USER_ID', 'user_id');
define('URL_POSTCARD_ID', 'postcard_id');
define('URL_PAGE', 'page');
define('URL_ID', 'id');

// User levels
define('GUEST', -1);
define('USER_AWAITING', 1);
define('USER', 2);
define('ADMIN', 9);

// Permission levels
define('AUTH_ALL', 0);
define('AUTH_USER', 2);
define('AUTH_ACL', 3);
define('AUTH_ADMIN', 9);

// Group types
define('GROUPTYPE_GROUP', 1);
define('GROUPTYPE_SINGLE', 2);

// Chmod for files and directories created by 4images
define('CHMOD_FILES', 0666);
define('CHMOD_DIRS', 0777);

// Misc
define('REPLACE_EMPTY', '&nbsp;');
define('MAX_RATING', 5);
define('TIME_OFFSET', '+1');

// If you have a lot of images in your database,
// the random image function can make your programm slow.
// Try first to set "SHOW_RANDOM_CAT_IMAGE" to 0.
define('SHOW_RANDOM_IMAGE', 1);
define('SHOW_RANDOM_CAT_IMAGE', 0);

// Check existence of remote image files.
// If you choose 1, you could get sometimes timeout errors
define('CHECK_REMOTE_FILES', 1);

// Allow execution of PHP code in templates
define('EXEC_PHP_CODE', 1);

define('MEDIA_DIR', 'data/media');
define('THUMB_DIR', 'data/thumbnails');
define('MEDIA_TEMP_DIR', 'data/tmp_media');
define('THUMB_TEMP_DIR', 'data/tmp_thumbnails');
define('DATABASE_DIR', 'data/database');
define('TEMPLATE_DIR', 'templates');

define('SCRIPT_VERSION', '1.6.1');
?>

Offline Jan

  • Administrator
  • 4images Guru
  • *****
  • Posts: 5.024
    • View Profile
    • 4images - Image Gallery Management System
1.6.1 -> 1.7 update problem
« Reply #8 on: September 15, 2002, 09:28:19 AM »
Na also, da haben wirs doch ;)
Code: [Select]
define('SHOW_RANDOM_CAT_IMAGE', 0);
Wenn Du das auf 1 setzt, wird es auch nicht mehr gehen.

Jan
Your first three "must do" before you ask a question:
1. Forum rules
2. FAQ
3. Search

Offline AlohaChris

  • Newbie
  • *
  • Posts: 23
    • View Profile
1.6.1 -> 1.7 update problem
« Reply #9 on: September 15, 2002, 09:39:52 AM »
moment, ich will es ja, dass es geht.

als ich 4images auf 1.7 upgegraded habe, ging random image nicht. und es erschien diese error message (s. oben). daraufhin meintest du ja, es wuerde an der MySQL version (3.22) liegen. aber, wie gesagt, mit 1.6.1 funktioniert random image (mit MySQL ver. 3.22). :?:
jedoch aber nicht mit 1.7

Offline Jan

  • Administrator
  • 4images Guru
  • *****
  • Posts: 5.024
    • View Profile
    • 4images - Image Gallery Management System
1.6.1 -> 1.7 update problem
« Reply #10 on: September 15, 2002, 10:04:35 AM »
Ich hatte nicht gesehen, dass der Link oben zu Änderungen führt die noch bei einer alten Version von 4images nötig waren. Bei den neueren musst nur die Konstante ändern die ich oben beschrieben habe.

Eigentlich funktionierte das kategoriebezogene Zufallsbild bei Dir in Version 1.6.1 auch nicht da Du es durch setzen der Konstante auf 0 abgeschaltet hattest.

Gruß Jan
Your first three "must do" before you ask a question:
1. Forum rules
2. FAQ
3. Search