Pic Upload works but pics are not displayed

Upload screen shots for display in Roster

Moderator: Ulminia

Pic Upload works but pics are not displayed

Postby zanix » Mon Jun 23, 2008 12:00 am

Code: Select all
146: Table 'bellicosus.roster_addon_config' doesn't exist
SQL:
SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '13' ORDER BY `id` ASC;
File: lib/dbal/mysql.php
Line: 234

This is critical, none of your other addons should be working if this is the case
This table holds all of the config for all Roster addons
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: Pic Upload works but pics are not displayed

Postby Ulminia » Tue Jun 24, 2008 6:05 am

for some reason i missed the second sql query in the admin section that pulls the data from the table i converted the addon to use the $addon['config'] array so this is useless try uploading this new admin page in to the admin directory of the Rostergallery folder
Attachments
index.rar
(5.42 KiB) Downloaded 104 times
Ulminia of Zangarmarsh
Zonous of Zangarmarsh
Author of Roster Gallery
WoWRoster-Profiler Redesigner
User avatar
Ulminia
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 1223
Joined: Tue Jul 04, 2006 4:41 pm
Location: New Brunswick, Canada
Realm: Zangarmarsh (PvE) - US
gmail/gtalk: ulminia@gmail.com

Re: Pic Upload works but pics are not displayed

Postby TheVorhaut » Tue Jun 24, 2008 2:16 pm

After having upgraded to Build 3999, then 4100, having modified line 17&18 in index.php, having modified the TPL files and now having updated the index.php in the admin folder, I am back to where it all started :) .

No SQL error anymore but:
Images are still not viewable, neither in the gallery, nor in the admin section. As a result I guess it is still a file path problem.

In the admin section for the pending screenshots the browser shows the following path for a missing thumbnail:
Code: Select all
http://bellicosus.be.funpic.de/addons/RosterGallery/screenshots/thumbs/ss1-thumb.jpg

The correct path on the server is:
Code: Select all
http://bellicosus.be.funpic.de/components/com_wowroster/addons/RosterGallery/screenshots/thumbs/ss1-thumb.jpg


UPDATE:
Ok, I fixed the thumbnail path problem in the admin section.
body_apimage.tpl
Replace
Code: Select all
$apimgdir = 'addons' . DIR_SEP . 'RosterGallery' . DIR_SEP . 'screenshots' . DIR_SEP . 'thumbs' . DIR_SEP;

by
Code: Select all
$apimgdir = $addon['url_path'] . 'screenshots' . DIR_SEP . 'thumbs' . DIR_SEP;


body_uapimage.tpl
Replace
Code: Select all
$upimgdir = 'addons' . DIR_SEP . 'RosterGallery' . DIR_SEP . 'screenshots' . DIR_SEP . 'thumbs' . DIR_SEP;

by
Code: Select all
$upimgdir = $addon['url_path'] . 'screenshots' . DIR_SEP . 'thumbs' . DIR_SEP;


The trick is to not only replace the 'addons', but also to remove the statement . DIR_SEP . 'RosterGallery' . DIR_SEP. Otherwise the resulting path will look like this:
Code: Select all
http://bellicosus.be.funpic.de/components/com_wowroster/addons/RosterGallery//RosterGallery/screenshots/thumbs/ss1-thumb.jpg
Last edited by TheVorhaut on Tue Jun 24, 2008 2:49 pm, edited 2 times in total.
TheVorhaut
WR.net Apprentice
WR.net Apprentice
 
Posts: 21
Joined: Tue Jun 05, 2007 6:46 pm

Re: Pic Upload works but pics are not displayed

Postby TheVorhaut » Tue Jun 24, 2008 2:56 pm

Ok, here is a new problem now:
The thumbnails in the admin section show up correctly now but I cannot approve the images because there is nothing to checkmark or select, see screenshot.
Attachments
TheVorhaut
WR.net Apprentice
WR.net Apprentice
 
Posts: 21
Joined: Tue Jun 05, 2007 6:46 pm

Pic Upload works but pics are not displayed

Postby Ulminia » Tue Jun 24, 2008 8:01 pm

seeing this as well update soon
Ulminia of Zangarmarsh
Zonous of Zangarmarsh
Author of Roster Gallery
WoWRoster-Profiler Redesigner
User avatar
Ulminia
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 1223
Joined: Tue Jul 04, 2006 4:41 pm
Location: New Brunswick, Canada
Realm: Zangarmarsh (PvE) - US
gmail/gtalk: ulminia@gmail.com

Pic Upload works but pics are not displayed

Postby Ulminia » Tue Jun 24, 2008 8:19 pm

ver 3.0.4200 is in the download section shoudl have solved this issue
Ulminia of Zangarmarsh
Zonous of Zangarmarsh
Author of Roster Gallery
WoWRoster-Profiler Redesigner
User avatar
Ulminia
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 1223
Joined: Tue Jul 04, 2006 4:41 pm
Location: New Brunswick, Canada
Realm: Zangarmarsh (PvE) - US
gmail/gtalk: ulminia@gmail.com

Re: Pic Upload works but pics are not displayed

Postby TheVorhaut » Tue Jun 24, 2008 8:32 pm

Ok great. The admin section with pending and approving images works now.
Thumbnail gallery works, too.

Only thing that does not work is the main function:
Clicking on a thumbnail in the gallery to display an image in large size.
I guess it is a file path problem, too...

Update:
The vote button opens a very small new browser window with the image to vote for, almost unusable. The window has no vertical or horizontal scroll bars. It is only possible to see the complete contents of the window by clicking left and then do a "drag-scroll" to select all.
Last edited by TheVorhaut on Tue Jun 24, 2008 8:37 pm, edited 1 time in total.
TheVorhaut
WR.net Apprentice
WR.net Apprentice
 
Posts: 21
Joined: Tue Jun 05, 2007 6:46 pm

Pic Upload works but pics are not displayed

Postby zanix » Tue Jun 24, 2008 9:47 pm

Don't use DIR_SEP for url paths
On a windows server, the url will have back slashes ( \ ) so they will be invalid urls

Use DIR_SEP only for file paths
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Pic Upload works but pics are not displayed

Postby Ulminia » Wed Jun 25, 2008 3:53 am

new ver for download
Ulminia of Zangarmarsh
Zonous of Zangarmarsh
Author of Roster Gallery
WoWRoster-Profiler Redesigner
User avatar
Ulminia
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 1223
Joined: Tue Jul 04, 2006 4:41 pm
Location: New Brunswick, Canada
Realm: Zangarmarsh (PvE) - US
gmail/gtalk: ulminia@gmail.com

Re: Pic Upload works but pics are not displayed

Postby shaun.voysey » Wed Jun 25, 2008 2:30 pm

Sorry about this Ulminia, This is a small list of errors i have come across.

do love the addon though.

------

Installation and/or Upgrade


Database Error
1366: Incorrect integer value: '' for column 'wrnet_id' at row 1

SQL:
UPDATE `roster_addon` SET `basename`='RosterGallery', `version`='3.0.4200', `active`=1, `fullname`='Roster Gallery', `description`='Guild Screenshot database.', `credits`='a:1:{i:0;a:2:{s:4:"name";s:27:"Ulminia";s:4:"info";s:41:"Guild Screenshot database (Alpha Release)";}}', `icon`='inv_misc_spyglass_03', `wrnet_id`='' WHERE `addon_id`=20;
File: lib\dbal\mysql.php
Line: 234



The Addon will not upgrade or install without this. Not too sure what the Value should be.

install.def.php

under
var $oldversion = '';

Add
var $wrnet_id = '0';



------

Configuration


You have to reload the RosterCP -> RosterGallery admin pages to see the changes. When you save the settings, the display reverts to what it was.


------

Voteing Settings

Does not set the settings to Normal.


------

Deleting Images

Addon does not delete images. Comes up with this message :-

ERROR RG:001-DS - screenshots/cat1/ss1.jpg Does not exist Cannot Delete

------

Other than that. The Main pictures show Ok. Along with the Captions and comments. Keep up the good work.



My System configuration is :

Windows 2003 Server (Yes, It's a windows Server :D, though I am thinking of LAMPing it.)
IIS 6


By the way, just to be a little picky. I thought you would have used the icon Of the 'faded Photograph' :P
Last edited by shaun.voysey on Wed Jun 25, 2008 6:50 pm, edited 1 time in total.
User avatar
shaun.voysey
WR.net Apprentice
WR.net Apprentice
 
Posts: 70
Joined: Thu Aug 10, 2006 12:50 pm
Location: Berkshire, England

Pic Upload works but pics are not displayed

Postby Ulminia » Wed Jun 25, 2008 7:52 pm

wrnet_id should be 62

saved changes not reshowing is a reload issue where the $addon['config'] is not reladed after the changes are set ial look into this

voting - this is odd i will defanitly look in to this... or remove that option... the popup seems to work well

the files not deleting is a prob with the pathing im working on that issue now with the whole addon

ial make changes and add 3.0.4300 to the download section today

lol the icon may change on the next releas i dono yet working on big changes for 3.1
Ulminia of Zangarmarsh
Zonous of Zangarmarsh
Author of Roster Gallery
WoWRoster-Profiler Redesigner
User avatar
Ulminia
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 1223
Joined: Tue Jul 04, 2006 4:41 pm
Location: New Brunswick, Canada
Realm: Zangarmarsh (PvE) - US
gmail/gtalk: ulminia@gmail.com

Re: Pic Upload works but pics are not displayed

Postby TheVorhaut » Wed Jun 25, 2008 10:56 pm

The "open image when clicking on a thumbnail in gallery" functionality does still not work on my web site with the latest build. Here is a video I put on filefront, unfortunately it's too compressed to allow viewing of the URL in the address line and status line of the browser.
http://files.filefront.com/clip0001avi/;10795912;/fileinfo.html
Last edited by TheVorhaut on Wed Jun 25, 2008 10:58 pm, edited 1 time in total.
TheVorhaut
WR.net Apprentice
WR.net Apprentice
 
Posts: 21
Joined: Tue Jun 05, 2007 6:46 pm

Pic Upload works but pics are not displayed

Postby Ulminia » Thu Jun 26, 2008 12:35 am

think i got it all fixed get 3.0.4400 in the download section
Ulminia of Zangarmarsh
Zonous of Zangarmarsh
Author of Roster Gallery
WoWRoster-Profiler Redesigner
User avatar
Ulminia
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 1223
Joined: Tue Jul 04, 2006 4:41 pm
Location: New Brunswick, Canada
Realm: Zangarmarsh (PvE) - US
gmail/gtalk: ulminia@gmail.com

Re: Pic Upload works but pics are not displayed

Postby TheVorhaut » Thu Jun 26, 2008 1:36 pm

Unfortunately it does still not work when clicking on a thumbnail in the gallery. What is the normal behaviour ? A new window should pop up showing the image or is it shown in the current browser window ? In my case nothing happens when clicking on a thumbnail.
TheVorhaut
WR.net Apprentice
WR.net Apprentice
 
Posts: 21
Joined: Tue Jun 05, 2007 6:46 pm

Pic Upload works but pics are not displayed

Postby Ulminia » Thu Jun 26, 2008 2:08 pm

its sapose to show the image in the browser your best bet.. is to use lightbox then i hate cms's the border box is not even showing witch is odd...
Ulminia of Zangarmarsh
Zonous of Zangarmarsh
Author of Roster Gallery
WoWRoster-Profiler Redesigner
User avatar
Ulminia
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 1223
Joined: Tue Jul 04, 2006 4:41 pm
Location: New Brunswick, Canada
Realm: Zangarmarsh (PvE) - US
gmail/gtalk: ulminia@gmail.com

PreviousNext

Return to Roster Gallery

Who is online

Users browsing this forum: No registered users and 0 guests

cron