Guest wrote:

I'm experiencing a different sort of problem than anyone else here has mentioned as of yet.

First off I'd like to say I've been using 4images as a module in PHP-Nuke for about a year now. I run my website as a personal website and never bothered trying to do any kind of user integration until now. In the past I've just logged in with the Gallery Admin page. I had modified the admin section myself so as it was functional, and everything worked - well kinda.

I was never able to make the mod work as a module that I could still maintain the column on the left hand side like all other PHP-Nuke pages have - this irritated me. I was running Xitami as my webserver, and because of this I had a few other little problems with PHP-Nuke, and some other pages - generally when I submitted something like a new news article the page wouldn't load - it would submit, but not load - just things liek that.

A few days ago I formatted my computer and installed Apache, and the latest stable versions of PHP and MySQL - got PHP-Nuke 1.7 up and running, and have been importing my news articles and what not over in to it (Instead of upgrading I opted to do a fresh install and import data - I had a lot of half modified files I was hoping may have been contributing to the problem.

So when I got PHP-Nuke up and going I opted to look around for a new Galley - I didn't like anything, so I started looking into doing a fresh integration of the 4images module, hoping it would work. I then found your folks integration stuff. I went through each step, several times, on the fresh install of 4images and php nuke- and I'm getting errors.

When I navigate to the "modules.php?name=Gallery" page I get the following error in 2 places:

Quote:

DB Error: Bad SQL Query: SELECT s.session_user_id, s.session_lastaction, s.session_ip, u.user_id, u.user_level2, u.username, u.user_invisible FROM 4images_sessions s LEFT JOIN nuke_users u ON (u.user_id = s.session_user_id) WHERE s.session_lastaction >= 1120834948 ORDER BY u.user_id ASC, s.session_ip ASC Table '4images.nuke_users' doesn't exist

One is at the very top of the screen, the other is just under my header. This is with the modules/Gallery/config.php and /config.php files pointing to the fresh install of 4images which has been modified using the included "ws4install.php"

If I modify my modules/Gallery/config.php and /config.php files to point to the Database that contains all my old Data, and run the script I get different errors:

Quote:

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.username FROM 4images_images i, 4images_categories c LEFT JOIN nuke_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND i.cat_id NOT IN (0, 180, 222, 220, 271, 278, 289, 333, 353) AND c.cat_id = i.cat_id LIMIT 1477, 1 Table 'pictures.nuke_users' doesn't exist 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.username FROM 4images_images i, 4images_categories c LEFT JOIN nuke_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id NOT IN (0, 180, 222, 220, 271, 278, 289, 333, 353) ORDER BY i.image_date DESC LIMIT 4 Table 'pictures.nuke_users' doesn't exist

Both Errors are located under the header of my PHP-Nuke Page, and above the 4images page. Yes this is also after modifying /config.php and then running the "ws4install.php" script.

When I go to modules/Gallery/admin/ in either of the above instances, it looks innocent enough, but when I try to log in it gives:

Quote:

DB Error: Bad SQL Query: SELECT user_id, user_password FROM nuke_users WHERE username = 'XXXXXX' AND user_level2 <> 1 Table 'pictures.nuke_users' doesn't exist Warning: Cannot modify header information - headers already sent by (output started at F:\Webpage\Apache2\htdocs\modules\Gallery\includes\db_mysql.php:188) in F:\Webpage\Apache2\htdocs\modules\Gallery\admin\admin_functions.php on line 168 Warning: Cannot modify header information - headers already sent by (output started at F:\Webpage\Apache2\htdocs\modules\Gallery\includes\db_mysql.php:188) in F:\Webpage\Apache2\htdocs\modules\Gallery\admin\admin_functions.php on line 169 Warning: Cannot modify header information - headers already sent by (output started at F:\Webpage\Apache2\htdocs\modules\Gallery\includes\db_mysql.php:188) in F:\Webpage\Apache2\htdocs\modules\Gallery\admin\admin_functions.php on line 170 Warning: Cannot modify header information - headers already sent by (output started at F:\Webpage\Apache2\htdocs\modules\Gallery\includes\db_mysql.php:188) in F:\Webpage\Apache2\htdocs\modules\Gallery\admin\admin_functions.php on line 171 Warning: Cannot modify header information - headers already sent by (output started at F:\Webpage\Apache2\htdocs\modules\Gallery\includes\db_mysql.php:188) in F:\Webpage\Apache2\htdocs\modules\Gallery\admin\admin_functions.php on line 172

I get this error with both the new and the old Databases linked up.

Also - I STILL don't have the Left hand Column - whats up with that?

Anyone have any suggestions? My webpage is set up at http://dewie.no-ip.com - Gallery is of course http://dewie.no-ip.com/modules.php?name=Gallery I am going to leave the fresh install version up online until I get an answer that will hopefully help me

Thanks folks!

Posted: Fri Jul 08, 2005 10:21 am

Guest wrote:

I am using only 4images here folks, however I did not install the 4images Database within my Nuke database. I installed it in its own seperate database called:

4images - for the fresh install I mentioned above
pictures - for my old install.

I did not realize I was supposed to install the 4images database within my nuke database - how I missed that I'm not sure...

I will give that a shot when I get back to my computer.

Thanks for the idea.

Posted: Fri Jul 08, 2005 10:03 pm

Guest wrote:

uzme tatli canini oksa patlicanini

Posted: Sat Jul 16, 2005 10:34 am

Guest wrote:

Just an update:

Somehow I managed to mess up the placement of the database information as mentioned above. The module now works - Thank-you for the help.

Posted: Mon Aug 08, 2005 10:56 am