Forums / General Questions / linux install issue?

linux install issue?

Locked

Started by ary on 2 Jan 2007, 7:58 AM · Views: 2,529

Results 1 to 11 of 11
This thread is locked. New replies are disabled.
2 Jan 2007, 7:58 AM
#1
ary avatar

ary

New Zenner

Join Date:
Dec 2006
Posts:
71
Plugin Contributions:
0

linux install issue?

when i install 1.3.6 in linux,a issue so it can not work:pls help,dear!


3 Jan 2007, 12:20 AM
#2
ary avatar

ary

New Zenner

Join Date:
Dec 2006
Posts:
71
Plugin Contributions:
0

Re: linux install issue?

why they are blank?


3 Jan 2007, 12:22 AM
#3
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,511
Plugin Contributions:
176

Re: linux install issue?

No idea.

Perhaps your database didn't install properly?
Perhaps your table-prefixes didn't build correctly?

The way the code is written, that should never happen ... and I've never seen it happen before.

Were there any warnings/errors that you chose to ignore on the System Inspection page?

What are your system/server's specifications?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

3 Jan 2007, 12:32 AM
#4
ary avatar

ary

New Zenner

Join Date:
Dec 2006
Posts:
71
Plugin Contributions:
0

Re: linux install issue?

Warning:
Your database appears to need patching to a higher level. See Admin->Tools->Server Information to review patch levels.


3 Jan 2007, 3:04 AM
#5
ary avatar

ary

New Zenner

Join Date:
Dec 2006
Posts:
71
Plugin Contributions:
0

Re: linux install issue?

wait for help!


3 Jan 2007, 3:52 AM
#6
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,511
Plugin Contributions:
176

Re: linux install issue?

What is the URL to your zc_install/techsupp.php ?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

3 Jan 2007, 9:58 PM
#7
fymbscu avatar

fymbscu

New Zenner

Join Date:
Jan 2006
Posts:
38
Plugin Contributions:
0

Re: linux install issue?

Hey DrByte,

I have run afoul of the same database patch issue, albeit with afresh install of 1.3.7 after importing my database from 1.3.5. Here's the error:

Your database appears to need patching to a higher level. See Tools->Server Information to review patch levels.

The error shows up at the top of the page of both the shop and the admin.

When going to the Tools->Server Information page, I don't know what information I am looking for or what further steps to take to address the issue.

I have attached a zipped PDF of my zc_install/techsupp.php.

All help greatly appreciated.

Regards,

Mark Harrison

6 Jan 2007, 4:59 AM
#8
fymbscu avatar

fymbscu

New Zenner

Join Date:
Jan 2006
Posts:
38
Plugin Contributions:
0

Re: linux install issue?

Hi guys,

Still unsuccessful in "patching" database or otherwise removing the bright red warning quoted above. On the cusp of taking the site live, but need to remove this warning before going further. The warning wasn't there when the database was empty. Only after populating the table with the 1.3.5 data.

All help appreciated. You can see the store here: http://bender.liquidweb.com/~limoleds/zc1370/

Thanks in advance,

Mark Harrison

6 Jan 2007, 5:56 AM
#9
Kim avatar

Kim

Obaa-san

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

Re: linux install issue?

Upgrade the database.

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.

8 Jan 2007, 11:19 PM
#10
fymbscu avatar

fymbscu

New Zenner

Join Date:
Jan 2006
Posts:
38
Plugin Contributions:
0

Re: linux install issue?

Hi Kim,

Thanks for the tip. I also found this forum thread helpful: http://www.zen-cart.com/forum/showthread.php?t=50389&highlight=patch+levels

What I figured out was that I did a clean install of 1.3.7 and then added my 1.3.5 backup data to my new empty 1.3.7 database after this step. This is when the patch level warnings appeared. I also found this to be true at my remotely hosted site (Linux) as well as my local development site (Macintosh). Thus, I don't believe this to be an Linux specific issue.

The key on both of my sites was to simply re-run the Zen Cart installer in order to have the database upgraded. Once this was done, all warnings disappeared.

Thanks again. Hoping to go live within 48 hours.

Regards,

Mark Harrison

9 Jan 2007, 1:08 AM
#11
fymbscu avatar

fymbscu

New Zenner

Join Date:
Jan 2006
Posts:
38
Plugin Contributions:
0

Re: linux install issue?

Hi folks,

Wanted to report that I got the following error when backing up my remote site with PHPmyadmin and then using the admin to restore to my local site:

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 '0'', ''1''),'');')' at line 1
in:
[INSERT INTO upgrade_exceptions (upgrade_exception_id, sql_file, reason, errordate, sqlstatement) VALUES (1, 'sql/mysql_upgrade_zencart_135_to_136.sql', 'Cannot ADD column get_term_table because it already exists.', '2007-01-08 17:50:58', 'ALTER TABLE get_terms_to_filter ADD get_term_table varchar(64) NOT NULL;'), (2, 'sql/mysql_upgrade_zencart_135_to_136.sql', 'Cannot ADD column get_term_name_field because it already exists.', '2007-01-08 17:50:58', 'ALTER TABLE get_terms_to_filter ADD get_term_name_field varchar(64) NOT NULL;'), (3, 'sql/mysql_upgrade_zencart_136_to_137.sql', 'Cannot insert configuration_key "DEFINE_PAGE_NOT_FOUND_STATUS" because it already exists', '2007-01-08 17:50:59', 'INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values (''Define Page-Not-Found Status'', ''DEFINE_PAGE_NOT_FOUND_STATUS'', ''1'', ''Enable the Defined Page-Not-Found Text from define-pages?
0= Define Text OFF
1= Define Text ON'', ''25'', ''67'', now(), now(), NULL, ''zen_cfg_select_option(array(''0'', ''1''),'');');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

This looks a lot like the "skipped" text listed on the Upgrade Database page when I worked through that step. (See previous post.) Despite this error, the restore looks to have completed as I have verified that changes made to the first site are now present on the second site.

I guess maybe this should be recorded as a "benign" bug? IF I am missing something more here, please advise.

Regards,

Mark Harrison