Messages

1

Plugins / [Plugin] Batch Import

« on: November 07, 2002, 01:52:47 AM »

set it to where your images or folders of images you want to add are located.

2

Mods & Plugins (Releases & Support) / Integration 4images 1.7 / phpBB

« on: October 09, 2002, 06:35:27 AM »

just in case this comes up for anyone else, I had a similar problem with deleting groups from my database.. the error I was receiving was:

Code: [Select]

DB Error: Bad SQL Query: DELETE FROM 4images_groups WHERE group_id =
You have an error in your SQL syntax near '' at line 2

DB Error: Bad SQL Query: DELETE FROM 4images_groupaccess WHERE group_id =
You have an error in your SQL syntax near '' at line 2

DB Error: Bad SQL Query: DELETE FROM 4images_groupmatch WHERE group_id =
You have an error in your SQL syntax near '' at line 2
Error while deleting User Group

once again for whatever reason the program was not reading the $group_id variable so it was attempting to insert it as a blank, which resulted in an SQL error.

my resolution was to look for:

Code: [Select]

if ($action == "deletegroup") {


and add this on the next line:

Code: [Select]


$group_id = intval($HTTP_POST_VARS['group_id']);


just a heads up..

3

Plugins / [Plugin] Batch Import

« on: October 09, 2002, 03:37:17 AM »

had a few problems with this mod, but got them worked out on my side with a few changes.. first error that came up was:

Code: [Select]

Parse error: parse error, unexpected T_STRING in /home/httpd/html/4images/admin/plugins/batch_import.php on line 70


i believe that was  because of the missing " on line 67:

Code: [Select]

// Default description for each image, can be left blank
$default_image_description = ";

which I changed to:

Code: [Select]

// Default description for each image, can be left blank
$default_image_description = "";

I then ran into a new error:

Code: [Select]

Fatal error: Failed opening required './../admin/admin_global.php' (include_path='.:/usr/lib/php') in /home/httpd/html/4images/admin/plugins/batch_import.php on line 29


which threw me off for a while, but I realized that for whatever reason, my system was not properly reading the root_path using this line:

Code: [Select]

$root_path = (eregi("\/plugins\/", $PHP_SELF)) ? "./../../" : "./../";

the only way I could get it to work with my limited knowledge of PHP was just to customize it specifically to my system which turned out to be:

Code: [Select]

$root_path = (/home/httpd/html/4images/");

after making these two changes the plugin worked flawlessly!

btw, great addition, this was a major feature I was looking forward to, thanks!  

4

Mods & Plugins (Releases & Support) / Integration 4images 1.7 / phpBB

« on: October 05, 2002, 07:00:57 PM »

that works, thanks!

5

Mods & Plugins (Releases & Support) / problem

« on: October 04, 2002, 07:39:52 PM »

the integration is working well for me, 4images detects all of my phpbb users and the sessions are working properly. My problem is when I goto do group management.. I attempt to add ANY of my 98 users to a 4images group and I get these errors:

Code: [Select]


DB Error: Bad SQL Query: DELETE FROM 4images_groupmatch WHERE user_id = AND group_id IN (1, 2, 3, 6)
You have an error in your SQL syntax near 'AND group_id IN (1, 2, 3, 6)' at line 2

DB Error: Bad SQL Query: INSERT INTO 4images_groupmatch (group_id, user_id, groupmatch_startdate, groupmatch_enddate) VALUES (1, , UNIX_TIMESTAMP('2002-10-04 10:43:05'), 0)
You have an error in your SQL syntax near ' UNIX_TIMESTAMP('2002-10-04 10:43:05'), 0)' at line 4

DB Error: Bad SQL Query: INSERT INTO 4images_groupmatch (group_id, user_id, groupmatch_startdate, groupmatch_enddate) VALUES (2, , UNIX_TIMESTAMP('2002-10-04 12:38:36'), 0)
You have an error in your SQL syntax near ' UNIX_TIMESTAMP('2002-10-04 12:38:36'), 0)' at line 4
User edited


for whatever reason it's not seeing my user_id's and is just trying to insert them into the database as a blank.

in my includes/constants.php I have defined:

Code: [Select]

define('USERS_TABLE', 'phpbb_users');

to point to my users directory, and it seems to work for everything but group management. Thanks for any input!