I am filling in all the fields on the upload screen for an image, a image (ss1.jpg) is appearing in the Screenshots folder and IS the correct image (not the name I gave it however) but on upload I receive the following error:


1364: Field 'approve' doesn't have a default value
SQL:
INSERT INTO `roster_addon_screenshots` ( `id` , `file` , `caption` , `ext`, `catagory` ) VALUES ( NULL , 'ss1', 'Starblade homage to the Queen.', 'jpg', 'Great Moments in Guild History');
File: functions.php
Line: 220

What am I missing?

try updating your functions file with this one and make sure that your have at least php 4.1

and as a point the RG addon renames the screen shot so that photos with the same name do not occure

Nope....

Just get a plain white page now....

next?

... with out an error its hard to trouble shoot see if the the image is in the folde and in the database if not try and get a script code that shows all errors and warnings

Well, with the new functions you gave me I only get a white screen now, not even the ability to submit or anything.

(http://starblade.zapto.org))

Just click the Roster Gallery button to see what I mean.
Before I copied in the new functions I could at least access the menu and upload (and generate the error I posted), now... well... nothing.

I do look forward to it working, sounds great as a concept.

id like to help witht hjis but i am at a loss as to what is happaning id like to say agian check your php info make sure that uploads are one only thing i can think of

also your site is not showing up

We had a power outtage, sorry, should be back now.

Please follow these troubble shooting steps

1 delete the entire package from the server and recopy the 2.1 version in the downloads section

2 backup and remove all data and tables for the addon in the database in roster config thay are defined with addon_rg

3 Test uploads on your server with the siggen addon by uploading a custome background

and 4 add error_reporting(E_ALL); to the verry top of the index.php in ther addon folder

Ok, think I found the problem. The database hasn't installed the sql updates for your addon when the install executed:

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 1
STR: <?
SQL: <?php
/******************************
*
* $Id: sql.inc,v 1.11 2006/06/01 11:42:23 Ulminia Exp $
*
******************************/

$create_sql['install'] = "
CREATE TABLE `".ROSTER_SCREENTABLE."` (
`id` int(11) NOT NULL auto_increment,
`file` varchar(255) NOT NULL,
`caption` varchar(255) NOT NULL,
`ext` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ";


SQL query:

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<?php

$create_sql['install'] = "
CREATE TABLE `".ROSTER_SCREENTABLE."` (
' at line 1

In fact that there is no roster_screentable in my roster database indicated that the sql didn't install in the first place. There IS a roster_addon_screenshots however.

roster_screentable if used to define roster_addon_screenshots in the script but how ever the script does not use the sql.inc file any more. pleases backup and drop the roster_addon_screenshots table and browse the roster_config table and remove any thing with addon_rg in the config_type colume. and please follow my troubble shooting steps there is a reasion for there order

Ok,

1) Deleted roster_addon_screenshots table - check
2) Crawl thru the roster_config and there was NOTHING with addon_rg at all to remove
3) Deleted the folder RosterGallery from the addons folder - check
4) Access the roster, no button for gallery (big surprise)
5) DL the currect version from the web site, extract, copy folder to addons - check
6) Access the roster, button for Roster Gallery, asks to install, so install - check
7) Access the roster, click Roster Gallery
white screen with:
"installDb: 1050: Table 'roster_addon_screenshots' already exists"
8 ) Access the roster, click Roster Gallery (again), attempt to upload image;
1364: Field 'approve' doesn't have a default value
SQL:
INSERT INTO `roster_addon_screenshots` ( `id` , `file` , `caption` , `ext`, `catagory` ) VALUES ( NULL , 'ss1', 'Homage to the queen', 'jpg', 'Special Events');
File: functions.php
Line: 220

(yep, it hates me)

ok try agian this time drop the roster_addon_screenshots table and make sure that there are no lines in the roster config go here http://wowroster.net/Downloads/details/id=62.html download 2.1 version extract in the addons folder open conf.php confirm that 2.1 is the ver
then run on webpage do install it should install and add and update 11 or 12 rows in the roster config table then it should work

Ulminia wrote:ok try agian this time drop the roster_addon_screenshots table and make sure that there are no lines in the roster config go here http://wowroster.net/Downloads/details/id=62.html download 2.1 version extract in the addons folder open conf.php confirm that 2.1 is the ver
then run on webpage do install it should install and add and update 11 or 12 rows in the roster config table then it should work

1) dropped roster_addon_screenshots - check
2) downloaded (and verified in conf.php) version 2.1 - check
3) run on web page, click install:

installDb: 1048: Column 'id' cannot be null

I think you can duplicate this on my site yourself actually. Also, this time no roster_addon_screenshots was added, apparently a complete fail this time.

I apologize if you feel like I'm being a pest, I just want to make sure this idea works so that it's as error free as possible. I think it will be one of the better AddOns to have.

sql table

Code: Select all

CREATE TABLE `roster_addon_screenshots` (
  `id` int(11) NOT NULL auto_increment,
  `file` varchar(255) NOT NULL,
  `caption` varchar(255) NOT NULL,
  `ext` varchar(255) NOT NULL,
  `catagory` varchar(255) NOT NULL,
  `approve` varchar(3) NOT NULL,
  PRIMARY KEY  (`id`)
) ; 

roster config table

Code: Select all


INSERT INTO `roster_config` (`id`, `config_name`, `config_value`, `form_type`, `config_type`) VALUES (99010, 'rg_dspc', '1', NULL, 'addon_rg'),
(99009, 'rg_dct', '1', NULL, 'addon_rg'),
(99008, 'rg_sst', '0', NULL, 'addon_rg'),
(99007, 'rg_lpp', '3', NULL, 'addon_rg'),
(99005, 'rg_carray', 'Great Moments in Guild History:Special Events:Just Wierd:Portrait:Victory!!', NULL, 'addon_rg'),
(99006, 'rg_version', '2.1', NULL, 'addon_rg'),
(99004, 'rg_ipl', '4', NULL, 'addon_rg'),
(99003, 'rg_ipp', '12', NULL, 'addon_rg'),
(99002, 'rg_height', '200', NULL, 'addon_rg'),
(99001, 'rg_width', '275', NULL, 'addon_rg'),
(99011, 'rg_dscp', '1', NULL, 'addon_rg'),
(99030, 'rg_ssfolder', 'screenshots/', 'text', 'addon_rg');

 

or alternativly try using this function file agian im making changes on the fly that will soon work out all issues i hope