Uploade image failed

Upload screen shots for display in Roster

Moderator: Ulminia

Uploade image failed

Postby foxpur » Fri Nov 03, 2006 2:04 pm

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?
User avatar
foxpur
WR.net Apprentice
WR.net Apprentice
 
Posts: 49
Joined: Wed Jul 26, 2006 8:18 pm

Re: Uploade image failed

Postby Ulminia » Fri Nov 03, 2006 6:45 pm

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
Attachments
functions.rar
(3.72 KiB) Downloaded 346 times
Last edited by Ulminia on Fri Nov 03, 2006 9:46 pm, edited 1 time in total.
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: Uploade image failed

Postby foxpur » Sat Nov 04, 2006 12:03 am

Nope....

Just get a plain white page now....

next?
User avatar
foxpur
WR.net Apprentice
WR.net Apprentice
 
Posts: 49
Joined: Wed Jul 26, 2006 8:18 pm

Uploade image failed

Postby Ulminia » Sat Nov 04, 2006 7:26 am

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

Uploade image failed

Postby foxpur » Sat Nov 04, 2006 10:15 pm

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.
User avatar
foxpur
WR.net Apprentice
WR.net Apprentice
 
Posts: 49
Joined: Wed Jul 26, 2006 8:18 pm

Uploade image failed

Postby Ulminia » Sun Nov 05, 2006 4:34 am

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
Last edited by Ulminia on Sun Nov 05, 2006 4:37 am, edited 1 time in total.
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

Uploade image failed

Postby foxpur » Sun Nov 05, 2006 6:44 am

We had a power outtage, sorry, should be back now.
User avatar
foxpur
WR.net Apprentice
WR.net Apprentice
 
Posts: 49
Joined: Wed Jul 26, 2006 8:18 pm

Uploade image failed

Postby Ulminia » Sun Nov 05, 2006 2:23 pm

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

Uploade image failed

Postby foxpur » Sun Nov 05, 2006 3:20 pm

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.
Last edited by foxpur on Sun Nov 05, 2006 3:33 pm, edited 2 times in total.
User avatar
foxpur
WR.net Apprentice
WR.net Apprentice
 
Posts: 49
Joined: Wed Jul 26, 2006 8:18 pm

Uploade image failed

Postby Ulminia » Sun Nov 05, 2006 6:55 pm

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

Uploade image failed

Postby foxpur » Sun Nov 05, 2006 8:11 pm

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)
Last edited by foxpur on Sun Nov 05, 2006 8:14 pm, edited 3 times in total.
User avatar
foxpur
WR.net Apprentice
WR.net Apprentice
 
Posts: 49
Joined: Wed Jul 26, 2006 8:18 pm

Uploade image failed

Postby Ulminia » Mon Nov 06, 2006 1:17 am

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 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: Uploade image failed

Postby foxpur » Mon Nov 06, 2006 1:29 am

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.
User avatar
foxpur
WR.net Apprentice
WR.net Apprentice
 
Posts: 49
Joined: Wed Jul 26, 2006 8:18 pm

Uploade image failed

Postby Ulminia » Mon Nov 06, 2006 2:42 am

sql table

Code: Select all
CREATE TABLE `roster_addon_screenshots` (
  `
idint(11NOT NULL auto_increment,
  `
filevarchar(255NOT NULL,
  `
captionvarchar(255NOT NULL,
  `
extvarchar(255NOT NULL,
  `
catagoryvarchar(255NOT NULL,
  `
approvevarchar(3NOT 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');

 
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: Uploade image failed

Postby Ulminia » Mon Nov 06, 2006 7:19 am

or alternativly try using this function file agian im making changes on the fly that will soon work out all issues i hope
Attachments
functions.rar
(3.81 KiB) Downloaded 351 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

Next

Return to Roster Gallery

Who is online

Users browsing this forum: No registered users and 0 guests

cron