Jump to content

Archived

This topic is now archived and is closed to further replies.

VideoDude

What's wrong with this picture???

Recommended Posts

Ok, I just re-loaded phpmyadmin with an updated version and NOW the my osC database appears (like it should). Jeff... an answer to your question will follow shortly.

Share this post


Link to post
Share on other sites

which version of php are you running on your server....it looks like a problem osc has with php 4.3...i noticed similar issues when my hosting switched from 4.2 to 4.3.......?


I am just a newbee....

Share this post


Link to post
Share on other sites

so no value is still showing in the admin panel even tho you changed the value, and you are still getting the error on the function....

 

this is very strange.... :?

 

time to put on the heavy duty thinking cap :)


Reading is beneficial - Searching is enlightening

find answers at wiki.oscommerce.com/top

Share this post


Link to post
Share on other sites

yes, no value shows in the admin panel. I need to qualify that a little. The 'My Store' info looks exactly as I had indicated in http://www.discountlearning.com/temp/osc2.jpg.

 

Now look at what appears when I choose 'edit' on the "Zone" row...

http://www.discountlearning.com/temp/osc4.jpg

 

(this is AFTER the changing the value to '12'... before it used to read "Pennsylvania")

Share this post


Link to post
Share on other sites

so its reading the table correctly, but for some unknown reason it is not showing the value in the table.. 12 is CA

 

that is what has me totally confused, which must mean it is something really simple that I am overlooking :lol: :lol:

 

ok, lets look at the other stuff

 

1) do you have a tax zone setup for PA

2) under configuration-shipping/packing are your country code and zip entered correctly

 

:roll: :? :roll: :wink:


Reading is beneficial - Searching is enlightening

find answers at wiki.oscommerce.com/top

Share this post


Link to post
Share on other sites

Yes, I have a tax zone set up for PA.

 

Here's what I have under shipping/packaging

 

Country Code = 'us'

Postal Code = '17501'

Max Package = '50'

Package Tare = '0'

Larger Packages = '10'

 

(crossing my fingers on that "country code" thing... I wasn't really certain what to enter here.

Share this post


Link to post
Share on other sites

US is the correct code (I dont think its case sensitive)

 

beat me with a 2x4 - this is really weird..... :?

 

one line...

 

what am I not seeing :cry:


Reading is beneficial - Searching is enlightening

find answers at wiki.oscommerce.com/top

Share this post


Link to post
Share on other sites

i just tried changing US to us on my site and it didnt make any difference..

 

its the STORE_ZONE configuration field - but there is nothing tied to that field other than the entry in the admin mystore panel - that is what is making this all so strange

 

are there any other screens in the admin panel where you are seeing FIELD_NAMES instead of the actual values? :?


Reading is beneficial - Searching is enlightening

find answers at wiki.oscommerce.com/top

Share this post


Link to post
Share on other sites

Clarification... under "Location/Taxes - Zones" there is a pre-existing entry for Pennsylvania.

 

Country = United States

Zone Name = Pennsylvania

Zone Code = PA

 

Also, I went into "Shipping/Packaging" and tried "US" (uppercase)... unfortunately it didn't resolve the issue.

 

:(

Share this post


Link to post
Share on other sites

Just about every other screen in the admin panel shows FIELD_NAMES instead of logical descriptors. Here's an example of the "Manufacturers" screen from the admin panel. Notice the column headings and the "TEXT_DATE_ADDED" above the "Canon" logo.

Share this post


Link to post
Share on other sites

all the data you are verifying is correct and just adds to the mystery....

 

I propose the following - lets leave it for tonight/this morning and pick it up again tomorrow

 

if you are in PA, I will be online around 1PM your time and depending on how busy things are, we can continue to disect this further..

 

i still think there is something off in the db.. but i cant put a finger on it :?


Reading is beneficial - Searching is enlightening

find answers at wiki.oscommerce.com/top

Share this post


Link to post
Share on other sites

since this is a new install, if you havent added data (other than your store data), then i would suggest using phpmyadmin and drop the configuration and configuration_group tables and reinstalling them using the SQL tab and paste in the following:

 

 

 

#

# Table structure for table `categories`

#

 

CREATE TABLE categories (

categories_id int(11) NOT NULL auto_increment,

categories_image varchar(64) default NULL,

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

sort_order int(3) default NULL,

date_added datetime default NULL,

last_modified datetime default NULL,

PRIMARY KEY (categories_id),

KEY idx_categories_parent_id (parent_id)

) TYPE=MyISAM;

 

 

 

#

# Table structure for table `configuration_group`

#

 

CREATE TABLE configuration_group (

configuration_group_id int(11) NOT NULL auto_increment,

configuration_group_title varchar(64) NOT NULL default '',

configuration_group_description varchar(255) NOT NULL default '',

sort_order int(5) default NULL,

visible int(1) default '1',

PRIMARY KEY (configuration_group_id)

) TYPE=MyISAM;


Reading is beneficial - Searching is enlightening

find answers at wiki.oscommerce.com/top

Share this post


Link to post
Share on other sites

Ok, this sounds like a deal. The toothpicks under my eyelids were becoming uncomfortable. :D

 

REALLY... I totally appreciate you taking the time to ponder this issue.

Share this post


Link to post
Share on other sites

make that

 

 

 

#

# Table structure for table `configuration`

#

 

CREATE TABLE configuration (

configuration_id int(11) NOT NULL auto_increment,

configuration_title varchar(64) NOT NULL default '',

configuration_key varchar(64) NOT NULL default '',

configuration_value varchar(255) NOT NULL default '',

configuration_description varchar(255) NOT NULL default '',

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

sort_order int(5) default NULL,

last_modified datetime default NULL,

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

use_function varchar(255) default NULL,

set_function varchar(255) default NULL,

PRIMARY KEY (configuration_id)

) TYPE=MyISAM;

 

#

# Table structure for table `configuration_group`

#

 

CREATE TABLE configuration_group (

configuration_group_id int(11) NOT NULL auto_increment,

configuration_group_title varchar(64) NOT NULL default '',

configuration_group_description varchar(255) NOT NULL default '',

sort_order int(5) default NULL,

visible int(1) default '1',

PRIMARY KEY (configuration_group_id)

) TYPE=MyISAM;


Reading is beneficial - Searching is enlightening

find answers at wiki.oscommerce.com/top

Share this post


Link to post
Share on other sites

So I went to go drop those tables through phpmyadmin. I selected the check-box next to each and then scrolled to the bottom of the screen to find the "drop" or "delete" button. Instead what I found was a message

 

Error

The additional Features for working with linked Tables have been deactivated. To find out why click here.

 

Clicking on the provided link resulted in

 

PMA Database ... not OK[ Documentation ]

General relation features Disabled

 

Might this have some bearing on this issue?

Share this post


Link to post
Share on other sites

more twilight zone music please :shock: :shock:

 

in phpmyadmin do you have tabs across the top where you can select a table in the left column and click the drop tab at the top?


Reading is beneficial - Searching is enlightening

find answers at wiki.oscommerce.com/top

Share this post


Link to post
Share on other sites

:? :oops: Ok, I found the drop tab (sorry, I didn't think to look there). In my rush to delete the tables you suggested I ended up dropping the "categories" table. AARGH!! Just like you're suggesting some MySQL commands to restore the other two tables, is there something similar I can use to restore the "categories" table?

Share this post


Link to post
Share on other sites

#

# Table structure for table `categories`

#

 

CREATE TABLE categories (

categories_id int(11) NOT NULL auto_increment,

categories_image varchar(64) default NULL,

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

sort_order int(3) default NULL,

date_added datetime default NULL,

last_modified datetime default NULL,

PRIMARY KEY (categories_id),

KEY idx_categories_parent_id (parent_id)

) TYPE=MyISAM;


Reading is beneficial - Searching is enlightening

find answers at wiki.oscommerce.com/top

Share this post


Link to post
Share on other sites

Oh Boy, Big problems. Top of the screen reads,

 

Error: There is currently no default currency set. Please set one at: Administration Tool->Localization->Currencies  

ERROR_NO_DEFAULT_LANGUAGE_DEFINED

 

And then there are 1064 errors on every Administration page

Share this post


Link to post
Share on other sites

×