Known bugs

A shopping addon for Roster

Moderator: Hannah

Known bugs

Postby Hannah » Sat Jul 08, 2006 4:53 pm

Known bugs

Shopping for roster


n/a (at the moment :)




Shopping for WoW


- if money less than 30 cooper messgae will not be send but state is changed
to send. (Need to add check!)
Last edited by Hannah on Wed Aug 16, 2006 12:24 pm, edited 1 time in total.
User avatar
Hannah
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 142
Joined: Tue Jul 04, 2006 1:41 pm
Location: Germany, Cologne

Known bugs

Postby sneekygit » Sun Jul 09, 2006 4:33 am

1st of all
can i just say
i hope i didnt post this in the wrong place

here is what im getting

error with the sql
something to do with the location/language
or timestamp
any ideas?

here is the error

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 'CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `order_state`
SQL:
CREATE TABLE `roster_addon_shopping` ( `order_number` int(255) NOT NULL auto_increment, `order_item` varchar(255) NOT NULL default '', `order_quantity` int(10) NOT NULL default '0', `order_maker` varchar(100) NOT NULL default '', `order_requester` varchar(100) NOT NULL default '', `order_maxprice` int(255) NOT NULL default '0', `order_note` varchar(255) NOT NULL default '', `order_price_demand` int(255) NOT NULL default '0', `order_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `order_state` enum('none','outbox','send','info') NOT NULL default 'none', `order_info` varchar(255) default NULL, PRIMARY KEY (`order_number`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
File: shoppingList.php
Line: 301
Last edited by sneekygit on Sun Jul 09, 2006 4:36 am, edited 1 time in total.
sneekygit
WR.net Apprentice
WR.net Apprentice
 
Posts: 40
Joined: Sun Jul 09, 2006 3:32 am

Re: Known bugs

Postby Hannah » Sun Jul 09, 2006 11:52 am

Hi sneekygit!

WHta is your mysql version ?

CU Hannah
User avatar
Hannah
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 142
Joined: Tue Jul 04, 2006 1:41 pm
Location: Germany, Cologne

Re: Known bugs

Postby Weeladdie » Sun Jul 09, 2006 4:58 pm

My users are getting the following error

Notice: Undefined offset: 0 in /homepages/20/d160505443/htdocs/outkasts/roster/addons/shopping/phpCart_manage.php on line 63

Warning: Cannot modify header information - headers already sent by (output started at /homepages/20/d160505443/htdocs/outkasts/roster/addons/shopping/phpCart_manage.php:63) in /homepages/20/d160505443/htdocs/outkasts/roster/addons/shopping/functions_cart.php on line

any ideas?
User avatar
Weeladdie
WR.net Apprentice
WR.net Apprentice
 
Posts: 12
Joined: Tue Jul 04, 2006 1:48 pm

Known bugs

Postby Hannah » Sun Jul 09, 2006 5:03 pm

Weeladdie wrote:My users are getting the following error

Notice: Undefined offset: 0 in /homepages/20/d160505443/htdocs/outkasts/roster/addons/shopping/phpCart_manage.php on line 63

Warning: Cannot modify header information - headers already sent by (output started at /homepages/20/d160505443/htdocs/outkasts/roster/addons/shopping/phpCart_manage.php:63) in /homepages/20/d160505443/htdocs/outkasts/roster/addons/shopping/functions_cart.php on line

any ideas?
This error occurs when you don´t change the file permission.

You have to chmod the file /roster/addons/Shopping/save/Shopping_list.lua
to 666..

CU

Hannah
User avatar
Hannah
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 142
Joined: Tue Jul 04, 2006 1:41 pm
Location: Germany, Cologne

Re: Known bugs

Postby sneekygit » Sun Jul 09, 2006 6:41 pm

MySQL Version 4.0.27-standard
php version 4.4.2
Last edited by sneekygit on Sun Jul 09, 2006 6:42 pm, edited 1 time in total.
sneekygit
WR.net Apprentice
WR.net Apprentice
 
Posts: 40
Joined: Sun Jul 09, 2006 3:32 am

Known bugs

Postby Hannah » Mon Jul 10, 2006 3:02 am

sneekygit wrote:MySQL Version 4.0.27-standard
php version 4.4.2
Try to run the sql query manually on your db (using phpmyadmin or command line)

If this doesn´t work, i´ll have a look at it at my home computer tomorrow...;)

Hannah

EDIT: I´ll check whethter i can change the query somehow...
Last edited by Hannah on Mon Jul 10, 2006 3:03 am, edited 1 time in total.
User avatar
Hannah
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 142
Joined: Tue Jul 04, 2006 1:41 pm
Location: Germany, Cologne

Known bugs

Postby sneekygit » Tue Jul 11, 2006 12:46 am

yeah tried running it manually
by pating the script into phpmyadmin

but still same thign

i even tried changing the location file to enUS
but that did nothing either
sneekygit
WR.net Apprentice
WR.net Apprentice
 
Posts: 40
Joined: Sun Jul 09, 2006 3:32 am

Re: Known bugs

Postby Hannah » Tue Jul 11, 2006 1:31 am

Think it has soething to do with the timestamp value, but i´m
a bit of confused that you´r so only one with that problem :)

Still testing...
User avatar
Hannah
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 142
Joined: Tue Jul 04, 2006 1:41 pm
Location: Germany, Cologne

Re: Known bugs

Postby aztlan » Tue Jul 11, 2006 3:56 pm

I've the same problem and same error...
My sql (same version sql and php of sneekygit) doesn't like the TIMESTAMP value. It seems to upset when i try to force it from phpmyadmin :P.
aztlan
WR.net Apprentice
WR.net Apprentice
 
Posts: 2
Joined: Thu Jul 06, 2006 2:35 pm

Re: Known bugs

Postby Hannah » Tue Jul 11, 2006 8:58 pm

OK, try the following (try cause i can´t replicate the error :)

Change the column typ from timestamp to datetime an the rest as seen in picture...

Tell me if it works :)
Attachments
User avatar
Hannah
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 142
Joined: Tue Jul 04, 2006 1:41 pm
Location: Germany, Cologne

Re: Known bugs

Postby ScratchMonkey » Tue Jul 11, 2006 9:52 pm

Hannah wrote:You have to chmod the file /roster/addons/Shopping/save/Shopping_list.lua
to 666..


Do that only if you have total control of the server. If it's a shared server, then you've just made that file available to all the other users on your server.

The file should probably be 660, with the ownership set to the user the webserver runs as ("apache" for Red Hat systems like Fedora).
User avatar
ScratchMonkey
WR.net Expert
WR.net Expert
 
Posts: 212
Joined: Wed Jul 05, 2006 4:32 pm
Location: San Pablo, CA

Re: Known bugs

Postby Hannah » Wed Jul 12, 2006 12:41 am

Oh, ok thx for the advice...
User avatar
Hannah
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 142
Joined: Tue Jul 04, 2006 1:41 pm
Location: Germany, Cologne

Known bugs

Postby ScratchMonkey » Wed Jul 12, 2006 2:58 am

I tend to be very sensitive to anyone advocating dropping security. That's what leads to sites getting hacked, like wowroster.net. You have to assume that everyone's out to get you, and create multiple layers of defense that have to be breached before someone can hack you. Paranoia is a server administrator's friend.

I see far too many PHP apps that trust too much. Particularly forum software that's complex and hard to analyze for weaknesses, except by those most interested in breaching the walls.
User avatar
ScratchMonkey
WR.net Expert
WR.net Expert
 
Posts: 212
Joined: Wed Jul 05, 2006 4:32 pm
Location: San Pablo, CA

Re: Known bugs

Postby Hannah » Wed Jul 12, 2006 11:07 am

I thought that 666 is not that easy to hack...but thx
for the advcie :)
User avatar
Hannah
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 142
Joined: Tue Jul 04, 2006 1:41 pm
Location: Germany, Cologne

Next

Return to Shopping

Who is online

Users browsing this forum: No registered users and 0 guests

cron