Forums / All Other Contributions/Addons / Warning i can't solve

Warning i can't solve

Views: 1,474

Results 1 to 14 of 14
21 Feb 2011, 3:06 PM
#1
stevefriedman71 avatar

stevefriedman71

Zen Follower

Join Date:
Sep 2006
Posts:
269
Plugin Contributions:
0

Warning i can't solve

On my "old" cart i had installed the rewardpoins module 1.12.c and it also affects the DB.
i am now redesigning the site and the rewards module is gone. I don't have any files of the mod in the new site and i deleted the tables that have "rewards" in it. yet, during the checkout, i still get this error (captured in jpg) iit says it can't find 2 files related to the mod...

http://test.themeltingpotonline.net/pix/errormessage.jpg

i tried to post in that thread but it seems the thread is dead

21 Feb 2011, 4:19 PM
#2
Kim avatar

Kim

Obaa-san

Join Date:
Jun 2003
Location:
West Coast, North America
Posts:
26,668
Plugin Contributions:
0

Re: Warning i can't solve

Did you remove the code that is looking for those files from your template?

Please do not PM for support issues: a private solution doesn't benefit the community.

Be careful with unsolicited advice via email or PM - Make sure the person you are talking to is a reliable source.

21 Feb 2011, 4:34 PM
#3
website_rob avatar

website_rob

Inactive

Join Date:
Oct 2006
Location:
Alberta, Canada
Posts:
4,572
Plugin Contributions:
0

Re: Warning i can't solve

In a situation of this type you can use: Admin > Tools > Developers Tool Kit to search for the text (ot_rewards_points) to see what file is using or referencing that text.

The learning is in the doing.

Potent Products

21 Feb 2011, 5:01 PM
#4
stevefriedman71 avatar

stevefriedman71

Zen Follower

Join Date:
Sep 2006
Posts:
269
Plugin Contributions:
0

Re: Warning i can't solve

Yes, i have no code for this mod on the new site. i did the dtk search and no files showed up.

21 Feb 2011, 5:13 PM
#5
website_rob avatar

website_rob

Inactive

Join Date:
Oct 2006
Location:
Alberta, Canada
Posts:
4,572
Plugin Contributions:
0

Re: Warning i can't solve

stevefriedman71:

Yes, i have no code for this mod on the new site. i did the dtk search and no files showed up.
So are you wrong or is Zen Cart?

No disrespect but we have to believe the error msg. is correct and it's just a matter of you searching for and finding, what file is causing the problem.

In DTK did you search for the same phrase I provided? If yes, then shorten it and try again.

Try rewards_points or ot_rewards

A gotcha with some Modules is that they provide a modified file to be uploaded and used. Does this apply to the module you were using?

You could also use your FTP program and check the Timestamp for files in:

includes/templates/YOUR_TEMPLATE/templates

A modified file from the module and uploaded afterwards will have a newer date.

The learning is in the doing.

Potent Products

21 Feb 2011, 5:27 PM
#6
stevefriedman71 avatar

stevefriedman71

Zen Follower

Join Date:
Sep 2006
Posts:
269
Plugin Contributions:
0

Re: Warning i can't solve

as i said. i didn't even install the mod to the test site. but i DID use the DB from the page that has it installed. from that DB, i deleted (dropped) a few tables that had the "rewards" in it.
I did even do a general search of the word "reward" in dtk and nothing showed up. The code is totally redone from scratch. the only connection it has to the "old" cart is the DB

21 Feb 2011, 5:35 PM
#7
website_rob avatar

website_rob

Inactive

Join Date:
Oct 2006
Location:
Alberta, Canada
Posts:
4,572
Plugin Contributions:
0

Re: Warning i can't solve

A strength and weakness of a good coder is that they are very exact, so you threw me off by saying:

On my "old" cart i had installed the rewardpoins module ...
i am now redesigning the site and the rewards module is gone.

Which is different than:

i didn't even install the mod to the test site. but i DID use the DB from the page that has it installed.

Now that we know that, it is obvious the problem is in your database. Have you searched your Database for the same keyword(s) as you did in DTK?

Also, the module has an "uninstall.sql" file. Did you run that?

And just to confirm, is this the module you are using:
http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=1002

The learning is in the doing.

Potent Products

21 Feb 2011, 5:42 PM
#8
stevefriedman71 avatar

stevefriedman71

Zen Follower

Join Date:
Sep 2006
Posts:
269
Plugin Contributions:
0

Re: Warning i can't solve

Website Rob:

A strength and weakness of a good coder is that they are very exact, so you threw me off by saying:

On my "old" cart i had installed the rewardpoins module ...
i am now redesigning the site and the rewards module is gone.

Which is different than:

i didn't even install the mod to the test site. but i DID use the DB from the page that has it installed.

Now that we know that, it is obvious the problem is in your database. Have you searched your Database for the same keyword(s) as you did in DTK?

Also, the module has an "uninstall.sql" file. Did you run that?
The mod didn't came with with an uninstall and i ran it a few times. but it still shows. I checked the DB and the 3 tables are gone. here is the code> DROP TABLE IF EXISTS reward_master;
DROP TABLE IF EXISTS reward_customer_points;
DROP TABLE IF EXISTS reward_status_track;

SET @group_id = '';
SELECT (@group_id := configuration_group_id) FROM configuration_group WHERE configuration_group_title LIKE 'Reward Points';
DELETE IGNORE FROM configuration WHERE configuration_group_id=@group_id;

DELETE IGNORE FROM configuration_group WHERE configuration_group_title='Reward Points';

I just found some inside the DB in a table. now, how can i delete that w/o messing up the whole thing?

21 Feb 2011, 5:50 PM
#9
website_rob avatar

website_rob

Inactive

Join Date:
Oct 2006
Location:
Alberta, Canada
Posts:
4,572
Plugin Contributions:
0

Re: Warning i can't solve

You would need to post what you found.

The learning is in the doing.

Potent Products

21 Feb 2011, 5:57 PM
#10
stevefriedman71 avatar

stevefriedman71

Zen Follower

Join Date:
Sep 2006
Posts:
269
Plugin Contributions:
0

Re: Warning i can't solve

1 match(es) inside table layout_boxes and i have a link to "browse" or "delete"
SQL result

Host: localhost
Database: themelti_test
Generation Time: Feb 21, 2011 at 12:52 PM
Generated by: phpMyAdmin 3.3.9 / MySQL 5.0.91-community
SQL query: SELECT * FROM themelti_test.layout_boxes WHERE (layout_id LIKE '%rewards%' OR layout_template LIKE '%rewards%' OR layout_box_name LIKE '%rewards%' OR layout_box_status LIKE '%rewards%' OR layout_box_location LIKE '%rewards%' OR layout_box_sort_order LIKE '%rewards%' OR layout_box_sort_order_single LIKE '%rewards%' OR layout_box_status_single LIKE '%rewards%') LIMIT 0, 30 ;
Rows: 1
layout_id 111
layout_template meltingpot
layout_box_name shopping_cart_with_rewards.php
layout_box_status 1
layout_box_location 1
layout_box_sort_order 0
layout_box_sort_order_single 0
layout_box_status_single 0

21 Feb 2011, 7:45 PM
#11
stevefriedman71 avatar

stevefriedman71

Zen Follower

Join Date:
Sep 2006
Posts:
269
Plugin Contributions:
0

Re: Warning i can't solve

looks like i solved it. thank you all

22 Feb 2011, 1:00 AM
#12
website_rob avatar

website_rob

Inactive

Join Date:
Oct 2006
Location:
Alberta, Canada
Posts:
4,572
Plugin Contributions:
0

Re: Warning i can't solve

Good to hear things are sorted out. Thanks for the update.

The learning is in the doing.

Potent Products

26 Feb 2011, 11:06 PM
#13
stevefriedman71 avatar

stevefriedman71

Zen Follower

Join Date:
Sep 2006
Posts:
269
Plugin Contributions:
0

Re: Warning i can't solve

my bet... NOT solved. i just deleted the more of the DB and the shipping calculation stopped working... now, i need to figure out what i need to delete/edit in the DB to get these warnings away

28 Feb 2011, 2:41 AM
#14
website_rob avatar

website_rob

Inactive

Join Date:
Oct 2006
Location:
Alberta, Canada
Posts:
4,572
Plugin Contributions:
0

Re: Warning i can't solve

Might be better to hire someone who is familiar with database coding to sort the problem out for you. Best place I can think to start is asking the person who created the module.

The learning is in the doing.

Potent Products