Known bugs

A shopping addon for Roster

Moderator: Hannah

Re: Known bugs

Postby aztlan » Wed Jul 12, 2006 2:15 pm

Problem resolved...
Here the modified sql.php that creates the table in mysql 4.0.27.

<?php
/*
* $Date: 2006/06/28 19:40:53 $
* $Revision: 0.4 $
*/
$sql_install = "
CREATE TABLE `".$db_prefix."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` datetime default NULL,
`order_state` enum('none','outbox','send','info') NOT NULL default 'none',
`order_info` varchar(255) default NULL,
PRIMARY KEY (`order_number`)
) ENGINE=MyISAM AUTO_INCREMENT=1;";

?>

I modified timestamp value as suggested by you, and deleted the default charset that my version of mysql didn't like so much :P.
Made some test and it seems function as expected.
Thanks for your work hannah :D.
aztlan
WR.net Apprentice
WR.net Apprentice
 
Posts: 2
Joined: Thu Jul 06, 2006 2:35 pm

Re: Known bugs

Postby Hannah » Wed Jul 12, 2006 3:49 pm

Thx aztlan!

Changing it in the sql query...:)

Btw did you taste it with only removing the charset part and
leave the timestamp column untouched?
Last edited by Hannah on Wed Jul 12, 2006 4:05 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

Re: Known bugs

Postby Tolrac » Wed Jul 12, 2006 5:16 pm

Hi, it's possible to modify the files for wowroster 1.6 nuked ?

I use the wowroster 1.6 phpnuke integration and i need to use the shopping addon but it's not compatible with this version.

Thank you in advance for your help.
Tolrac
WR.net Apprentice
WR.net Apprentice
 
Posts: 30
Joined: Tue Jul 04, 2006 1:22 pm

Known bugs

Postby Hannah » Wed Jul 12, 2006 10:00 pm

Tolrac wrote:Hi, it's possible to modify the files for wowroster 1.6 nuked ?

I use the wowroster 1.6 phpnuke integration and i need to use the shopping addon but it's not compatible with this version.

Thank you in advance for your help.
Wowroster 1.6 will no longer be supported (thats what i read about i think)
so if ou switch to 1.7 i´ll take a look into it.. (see download section)

CU Hannah :)

Btw a bit offtopic :)
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 Tolrac » Thu Jul 13, 2006 11:36 am

Hi,

OK, but the version 1.7 not working with phpnuke and autotheme, i use the version 1.6 with phpnuke.

I like to upgrade to version 1.7 but i have error message. and i modify the files and after i have blank page
Tolrac
WR.net Apprentice
WR.net Apprentice
 
Posts: 30
Joined: Tue Jul 04, 2006 1:22 pm

Re: Known bugs

Postby Hannah » Thu Jul 13, 2006 4:23 pm

1.6 is not in the downloadsection anymore, so it´s hard for me to take a look
into it :)

If you could send me a copy... (zip-file) i´ll take a look at 1.6
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 Tolrac » Thu Jul 13, 2006 6:02 pm

Ok, and where can i send to you a zip file with the roster version 1.6 for phpnuke module ?

thank you in advance for your help.
Tolrac
WR.net Apprentice
WR.net Apprentice
 
Posts: 30
Joined: Tue Jul 04, 2006 1:22 pm

Re: Known bugs

Postby Hannah » Thu Jul 13, 2006 7:46 pm

Have a look at the e-mail button below my avatar
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 Tolrac » Thu Jul 13, 2006 8:23 pm

There is the zip file with the roster 1.6 without the images folder for phpnuke and autotheme
Attachments
roster.zip
(5.78 MiB) Downloaded 82 times
Tolrac
WR.net Apprentice
WR.net Apprentice
 
Posts: 30
Joined: Tue Jul 04, 2006 1:22 pm

Known bugs

Postby sneekygit » Thu Jul 13, 2006 8:50 pm

ok

tried the modified code
run it via the shopping button
and by putting it as an sql querry

and this is what i get

Error

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
/*
* $Date: 2006/06/28 19:40:53 $
* $Revision: 0.4 $
*/
$sql_install = "
CREATE TABLE `".$db_prefix."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` datetime default NULL,
`order_state` enum('none','outbox','send','info') NOT NULL default 'none',
`order_info` varchar(255) default NULL,
PRIMARY KEY (`order_number`)
) ENGINE=MyISAM AUTO_INCREMENT=1;";


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

$sql_install = "
CREATE TABLE `".$db_prefix."addon_sh


do i need to have the lua file on my web server before it will create the tables?


i am also getting this at the top of the page when i click shopping cart

?php /* * $Date: 2006/06/28 19:40:53 $ * $Revision: 0.4 $ */ $sql_install = " CREATE TABLE `".$db_prefix."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` datetime default NULL, `order_state` enum('none','outbox','send','info') NOT NULL default 'none', `order_info` varchar(255) default NULL, PRIMARY KEY (`order_number`) ) ENGINE=MyISAM AUTO_INCREMENT=1;"; ?>

no idea why the date is wrong

it is set properly in phpnuke
Last edited by sneekygit on Thu Jul 13, 2006 8:52 pm, 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 » Thu Jul 13, 2006 10:01 pm

The problem is the missing variable $db_prefix....
and not hte date :)

I don´t know what your db_prefix is but suggest it was

masterprefix_

the sql should look like this:
Code: Select all

CREATE TABLE 
`masterprefix_addon_shopping` (
`
order_numberint(255NOT NULL auto_increment,
`
order_itemvarchar(255NOT NULL default '',
`
order_quantityint(10NOT NULL default '0',
`
order_makervarchar(100NOT NULL default '',
`
order_requestervarchar(100NOT NULL default '',
`
order_maxpriceint(255NOT NULL default '0',
`
order_notevarchar(255NOT NULL default '',
`
order_price_demandint(255NOT NULL default '0',
`
order_datedatetime default NULL,
`
order_stateenum('none','outbox','send','info'NOT NULL default 'none',
`
order_infovarchar(255) default NULL,
PRIMARY KEY (`order_number`)
ENGINE=MyISAM AUTO_INCREMENT=1;
 



Take this code and run it in phpmyadmin manually but change the prefix to your prefix...:)

Hope this helps

Btw plz make a new thread with your question cause this is the known bug section and i think it´s no bug, it´s because of phpnuke...:)
Last edited by Hannah on Thu Jul 13, 2006 10:01 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 16, 2006 4:33 am

bingo
sorted

changed it to
CREATE TABLE `roster_addon_shopping`
and it fixed it

thanks again
sneekygit
WR.net Apprentice
WR.net Apprentice
 
Posts: 40
Joined: Sun Jul 09, 2006 3:32 am

Re: Known bugs

Postby Tolrac » Tue Jul 18, 2006 8:26 pm

Hi,

Have you modify the code for the roster 1.6 ?

Thank you in advance.
Tolrac
WR.net Apprentice
WR.net Apprentice
 
Posts: 30
Joined: Tue Jul 04, 2006 1:22 pm

Known bugs

Postby Hannah » Tue Jul 18, 2006 10:03 pm

Haven´t got the time for it, but i´ll take a look at it the next days :)
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 Tolrac » Wed Jul 19, 2006 12:55 pm

Thank you...

I wait the modified code...
Tolrac
WR.net Apprentice
WR.net Apprentice
 
Posts: 30
Joined: Tue Jul 04, 2006 1:22 pm

PreviousNext

Return to Shopping

Who is online

Users browsing this forum: No registered users and 0 guests

cron