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

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

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

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.

seeing this as well update soon

ver 3.0.4200 is in the download section shoudl have solved this issue

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.

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

new ver for download

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 , 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'

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

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

think i got it all fixed get 3.0.4400 in the download section

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.

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...