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 .
Made some test and it seems function as expected.
Thanks for your work hannah .

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?

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

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

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

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.

Have a look at the e-mail button below my avatar

There is the zip file with the roster 1.6 without the images folder for phpnuke and autotheme

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

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

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

bingo
sorted

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

thanks again

Hi,

Have you modify the code for the roster 1.6 ?

Thank you in advance.

Haven´t got the time for it, but i´ll take a look at it the next days

Thank you...

I wait the modified code...