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

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

Hi sneekygit!

WHta is your mysql version ?

CU Hannah

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?

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

MySQL Version 4.0.27-standard
php version 4.4.2

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

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

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

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 .

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

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

Oh, ok thx for the advice...

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.

I thought that 666 is not that easy to hack...but thx
for the advcie