Jump to content
Sign in to follow this  
Druide

BUG TRACKING: Order Processing & Shipping Module v0.8

Recommended Posts

First of all thanks P & G for this HUGE release for MS1

 

It's time for some BUG TRACKING

 

 

Trying to install this and while adding spg_alter_table.sql i noticed that this file was not correct

 

ALTER TABLE customers_basket ADD attributes_cost DECIMAL(15,4) NOT NULL AFTER final_price, ADD attributes_weight DECIMAL(15,4) NOT NULL AFTER final_cost;

 

okay i am smart enough to figure this one out i thought but i haven't got the field final_cost so where to put this one ?

 

i added this

ALTER TABLE customers_basket ADD attributes_cost DECIMAL(15,4) NOT NULL AFTER final_price;

 

that works fine, should the next one be

 

ALTER TABLE customers_basket ADD attributes_weight DECIMAL(15,4) NOT NULL AFTER final_price;

 

also a little typo in same file

 

ALTER TABLE `countries` ADD `status` TINYINT(1) NOT NULL;

 

this should be

ALTER TABLE countries ADD status` TINYINT(1) NOT NULL;

 

to be continued...

 

BTW installing this on tep_snapshot-20030329.zip


Robert

 

We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;)

Share this post


Link to post
Share on other sites

another one

 

in install_v08_new_install.txt

 

ADMIN SIDE

----------





Step 1 admin/database_tables.php

--------------------------------

add lines below



 // define new tables for shipping module

 define('TABLE_SPG_CONFIG', ' spg_config');

 define('TABLE_SPG_CONFIG_LANGUAGE', ' spg_config_language');

 define('TABLE_SPG_MANUAL_INFO', 'spg_man_info');

 

this should be

 

ADMIN SIDE

----------





Step 1 admin/includes/application_top.php

--------------------------------

add lines below



 // define new tables for shipping module

 define('TABLE_SPG_CONFIG', ' spg_config');

 define('TABLE_SPG_CONFIG_LANGUAGE', ' spg_config_language');

 define('TABLE_SPG_MANUAL_INFO', 'spg_man_info');

 

hmmm

 

 

lots of error in the ADMIN area, i will collect them in a file and send by email or so....


Robert

 

We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;)

Share this post


Link to post
Share on other sites

Warning: open_basedir restriction in effect. File is in wrong directory in /home/........................./admin/spg_shipping.php on line 339



Warning: Failed opening 'includes/classes/shipping.php' for inclusion

 

and another in admin/spg_blacklist_admin.php?selected_box=shipping

 

1054 - Unknown column 'p.customers_blacklist' in 'field list'



select p.customers_id, p.customers_lastname, p.customers_firstname, p.customers_email_address, p.customers_blacklist from customers p order by p.customers_lastname limit 0, 20



[TEP STOP]

 

and in admin/spg_payment_admin.php?selected_box=shipping

 

1146 - Table 'ss0329.spg_payment_type' doesn't exist



select count(*) as total from spg_payment_type p

 

i stop here for now...

 

the list continues :(


Robert

 

We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;)

Share this post


Link to post
Share on other sites

go to http://64.255.9.69/oscdownload/

Hello

 

 

get the latest zip there.

 

 

all problems reported were fixed this morning. new zip should contain all bugs fixes

 

 

read the new instructions for the version to be used

 

 

we have 2 sets of install text : one for new versions and one for

users who already have a prior version of our module installed

 

 

 

thank you again for taking the time to report install problems

Share this post


Link to post
Share on other sites

thanks for the UPDATE :)

 

it seems to work well my my snapshot MS2 03292003

 

1 question though:

 

can you give an example for this

 

7. Added page comments admin screen

(Test in MS1 but can be cut and pasted in any version since it is only comment field shown)

** You need to add the extras files in zip to be able to use the admin screen  

 

Basically we added comment fields to main store pages  

 

product_info

default

shopping cart

payment

shipping.....

 

This modules allows you to modify comments appearing on the page directly from this screen.

 

there are no extra files in the zip only an empty folder /extras/

 

I just made this SQL from the errors that i got and by reading the file

 

CREATE TABLE products_comments (

 products_id  int(11) NOT NULL default '0',

 products_comments_id int(11) NOT NULL default '0',

 products_comments_status tinyint(1) NOT NULL default '0',

 products_comments_name varchar(150) NOT NULL default '',

 products_comments_desc varchar(255) NOT NULL default '',

 products_comments_class varchar(100) NOT NULL default '',

 expires_date datetime default NULL,

 date_status_change datetime NOT NULL default '0000-00-00 00:00:00',

 document_last_modified datetime NOT NULL default '0000-00-00 00:00:00'

) TYPE=MyISAM;

 

did i missed anything ?

 

Thanks for the HELP


Robert

 

We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;)

Share this post


Link to post
Share on other sites

This looks like a really cool and rather massive mod. Thanks for all the work put into this. Can I ask a favor though, could you post a few screenshots so I can get a feel for exactly what this is and how it intigrates...?

 

Thanks

 

-D. M.


-D. M. 8)

Share this post


Link to post
Share on other sites

there are MANY screens and we dont want to use bandwidth from osC

 

just install it on a clean MS1 or up

 

just 10 minutes and your ready to try it out


Robert

 

We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;)

Share this post


Link to post
Share on other sites

hello

 

1. if you download latest latest latest zip from our test site

 

http://64.255.9.69/oscdownload/

 

we added in sql script info for this table.

 

table is called products_comments in sql file

 

(in fact it takes more time to package that module correctly than to develop it and we forgot to include it in first sql)

 

 

2. in the extras : i added as well several examples pages where we added already the comment field

 

quite simple in fact : query is

 

<tr>

<td class="smallTextR"><br><br><br>

[ <?php

$sales_comments_query = tep_db_query("select s.products_comments_desc, s.products_comments_class from " . TABLE_PRODUCTS_COMMENTS . " s where s.products_comments_id= '4' and s.products_comments_status = '1' ");

$sales_comments = tep_db_fetch_array($sales_comments_query);

echo $sales_comments['products_comments_desc'] ;

?> ]

</td></tr>

 

 

 

in query s.products_comments_id= '4' , just need to change the id number 4 to whatever id you created in the admin page. we show the id there

 

 

you can place the comment block wherever you feel in the needed pages.

 

 

** note: we created a new class in stylesheet

 

class="smallTextR" for samll bold red text but you can use anything you want

Share this post


Link to post
Share on other sites

Hmm... well my site is already heavily modded. I think it would take more than 10 minutes to do a clean install and then re-install all the mods. Or maybe you're suggesting that I put up a second osC site to test this contribution...?

 

Upon closer inspection it seems that only three original files are touched, though I could be wrong and I hope someone is kind enough to tell me if there are more than this : orders.php in the admin section, and then account_history.php and then account_history_info.php in the catalog section. Perhaps I could just re-install my mods to those three files and then everything would work...?

 

there are MANY screens and we dont want to use bandwidth from osC

is it really that large that you couldn't put some screens in a zip file and up them somewhere...? This must be a really friggin large mod...

 

Well I guess I'll just poke through this a bit more and make sure that it won't be too messy to remove if it's not quite right.

 

-D. M.


-D. M. 8)

Share this post


Link to post
Share on other sites

the last time we did open an "admin test preview admin" some trashed our test site by changing everything and we waisted a full day reconfiguring our work.

 

 

thus now we prefer not to waite our time again.

Share this post


Link to post
Share on other sites

found another missing field date_status_change

 

 

 

my (i hope) now complete table products_comments

 

CREATE TABLE products_comments (

 products_comments_id int(11) NOT NULL auto_increment,

 products_comments_name varchar(40) NOT NULL default '',

 products_comments_desc longtext NOT NULL,

 products_comments_class varchar(15) NOT NULL default '',

 products_id int(11) NOT NULL default '0',

 products_comments_status tinyint(1) NOT NULL default '0',

 date_status_change datetime NOT NULL default '0000-00-00 00:00:00',

 products_comments_image varchar(35) NOT NULL default '',

 products_comments_order int(2) NOT NULL default '0',

 last_modified datetime NOT NULL default '0000-00-00 00:00:00',

 language_id int(3) NOT NULL default '0',

 date_added datetime NOT NULL default '0000-00-00 00:00:00',

 status tinyint(1) NOT NULL default '0',

 document_last_modified datetime NOT NULL default '0000-00-00 00:00:00',

 expires_date datetime NOT NULL default '0000-00-00 00:00:00',

 PRIMARY KEY  (products_comments_id)

) TYPE=MyISAM;


Robert

 

We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;)

Share this post


Link to post
Share on other sites

i have installed the contribution but i cnat figure out how to enable the Payment Methods.

 

here is what is set in my admin section of Shipping by P&G

 

But Admin => Shipping => Payment Admin

 

Snap1.gif

 

And this is what my Catalog is showing :

 

Snap2.gif

 

I have enabled 2Checkout through Admin => Modules => Payment

 

How do I make the modules to show up at catalog. And I am not sure if everything is working but everything does show up.

 

I can provide you with my admin link to check out.

Share this post


Link to post
Share on other sites

i have installed the contribution but i cnat figure out how to enable the Payment Methods.

 

here is what is set in my admin section of Shipping by P&G

 

But Admin => Shipping => Payment Admin

 

Snap1.gif

 

And this is what my Catalog is showing :

 

Snap2.gif

 

I have enabled 2Checkout through Admin => Modules => Payment

 

How do I make the modules to show up at catalog. And I am not sure if everything is working but everything does show up.

 

I can provide you with my admin link to check out.

Share this post


Link to post
Share on other sites

what you need to do is use the payment admin screen in the shipping module to add a new payment method ie 2checkout in your case.

 

 

the reason why we did not link directly to the same payment table as OSC was that you are not limited to payment existing in osc

 

for example if you do auctions you can enter western union billpay, billpoint....... as payment even though they are not in OSC

 

it gives you more flexibility

 

 

 

same principle for the shipping methods.

 

you may sometines use a shipping method not used in OSc . especially if you enter manual orders. (client could have a shipping account with a carrier and you need to use his carrier not the one in OSC)

Share this post


Link to post
Share on other sites

Alright, But i want to add Western Union Payment Method to my payment methods. I currently have 2Checkout.

Share this post


Link to post
Share on other sites

Do you have a screen shot as how Western Union Works.

 

I want to use it as another payment method.

Share this post


Link to post
Share on other sites

SOME BUGS REPORTED:

 

shipping process: product name, quantity ship, quantity order ... doesn't appear (only sub total appear). TEXT_ALL_ORDERS in status isn't defined

 

manual entry admin: images doesn't exists

 

Question : authorize admin is only for information?

 

customers: problem with some html tags( some code appears under page title

 

Paiement type admin : Is there a link with paiements in use with osc or are they only here for shipping V.8 contrib?

 

order status admin: those are new value or they the one used in osc because i have a problem with language id

 

language admin: can't change status "1054 - Unknown column 'date_status_change' in 'field list'". Is the language id the one use in localization because when i try change language id in editing it doesn't change it

 

C'est tout pour le moment


PL DTM

-----------------------------------------

Sur un malentendu, ... ?a pourrait marcher

Share this post


Link to post
Share on other sites
SOME BUGS REPORTED:

language admin: can't change status "1054 - Unknown column 'date_status_change' in 'field list'". Is the language id the one use in localization because when i try change language id in editing it doesn't change it

check a few posts back b4 you post :)

(i know we all make the same mistakes sometimes ;) )

 

http://forums.oscommerce.com/viewtopic.php...er=asc&start=10


Robert

 

We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;)

Share this post


Link to post
Share on other sites

missing spg_customers table or must we modify all call to spg_customers towards customers??

 

 

 

Pldtm


PL DTM

-----------------------------------------

Sur un malentendu, ... ?a pourrait marcher

Share this post


Link to post
Share on other sites
missing spg_customers table or must we modify all call to spg_customers towards customers??

 

where did this popped up ?

 

I haven't tested it 100% yet

 

but i'm missing the table also


Robert

 

We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;)

Share this post


Link to post
Share on other sites

i saw that this contrib was made by francecontact.com. Is there someone at palmandgardens to explain me in french how to use it. I think i don't understand every menu and how to use it everyday.

 

 

pldtm


PL DTM

-----------------------------------------

Sur un malentendu, ... ?a pourrait marcher

Share this post


Link to post
Share on other sites

oui on peut donner des infos en francais egalement

 

mais on a plus de temps le soir (Miami time)

 

pour etre plus interactif tu peux utiliser le live support sur notre site.

 

previens nous avant pour convenir d une heure

Share this post


Link to post
Share on other sites

ok vers quelle heure chez vous car je crois que quand il est 21h00 a miami, il est 03h00 du matin chez nous

 

 

pldtm


PL DTM

-----------------------------------------

Sur un malentendu, ... ?a pourrait marcher

Share this post


Link to post
Share on other sites

i get this at the top of the page when i click

customer admin

 

 

 

 

<tr class="dataTableRowSelected" onmouseover="this.style.cursor='hand'" '">

<tr class="dataTableRow" onmouseover="this.className='dataTableRowOver';this.style.cursor='hand'" onmouseout="this.className='dataTableRow'" '">

<tr class="dataTableRow" onmouseover="this.className='dataTableRowOver';this.style.cursor='hand'" onmouseout="this.className='dataTableRow'" '"> 

<tr class="dataTableRow" onmouseover="this.className='dataTableRowOver';this.style.cursor='hand'" onmouseout="this.className='dataTableRow'" '">  

<tr class="dataTableRow" onmouseover="this.className='dataTableRowOver';this.style.cursor='hand'" onmouseout="this.className='dataTableRow'" '">  

<tr class="dataTableRow" onmouseover="this.className='dataTableRowOver';this.style.cursor='hand'" onmouseout="this.className='dataTableRow'" '">  

<tr class="dataTableRow" onmouseover="this.className='dataTableRowOver';this.style.cursor='hand'" onmouseout="this.className='dataTableRow'" '">  

 

 

 

 

i also get this when clicking

 

 

the little green icon to activate the listed customer

in a blacklist i guess

 

 

1146 - Table 'catalog.table_spg_customers' doesn't exist



update TABLE_SPG_CUSTOMERS set customers_blacklist = '1' where customers_id = '2'

 

 

i customer does exist looking at it . i click the green icon to activate and thats what i get .

 

 

 

 

how do we fix?

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×