27 replies to this topic

[spooks]

deneb69, on 24 March 2010, 18:03, said:

Please can you explain me this step:
To apply any SQL:

Ok I`ll try re-wording the instructions, hopefully it will become clear.

To apply any SQL with phpMyAdmin:

Log into your site cPanel then click on phpMyAdmin.


Once your logged into phpMyAdmin, you may see more than one database (listed on the left of the display), if so you will need to select your database from the dropdown list, the osC one is usually the larger one shown.

The left side will now show a list of all the tables within your database and the main part of the screen will show the table structure.

On a default osC setup the tables listed will be:

• address_book
• address_format
• administrators
• banners
• banners_history
• categories
• categories_description
• configuration
• configuration_group
• counter
• counter_history
• countries
• currencies
• customers
• customers_basket
• customers_basket_attributes
• customers_info
• geo_zones
• languages
• links
• links_categories
• link_description
• manufacturers
• manufacturers_info
• menu
• menu_colors
• newsletters
• orders
• orders_products
• orders_products_attributes
• orders_products_download
• orders_status
• orders_status_history
• orders_total
• page_description
• products
• products_attributes
• products_attributes_download
• products_description
• products_notifications
• products_options
• products_options_values
• products_options_values_to_products_options
• products_to_categories
• reviews
• reviews_description
• sessions
• specials
• tax_class
• tax_rates
• whos_online
• zones
• zones_to_geo_zones

If your display shows a very different list, select another database & re-check.

Across the top of the database display area you will see a nav bar that looks like:

Structure | SQL | Search | Export | Import | Operations

Select the SQL tab.

You should then get a box with a title like:

Run SQL query/queries on database xxxxx.

If there is anything in that box, empty it.

Enter your SQL query into that box.

At the bottom that box is a button that says "Go", click on that and phpMyAdmin will run the query.

If all is well your database will be updated with your querey and you will see a success message. [img]http://forums.oscommerce.com/public/style_emoticons/default/biggrin.gif[/img]

[deneb69]

thanks so much! now it's clear!

[blr044]

Thanks Sam, for your tip here on installing contribution. My question is, and I hope you do not think this being a dumb question. The instruction for vast majority of the contributions will instruct to add such code just before the last ?> in filename or the language file. Example below:

Quote

define('FILENAME_XXXXXXXXX', 'Xxxxxxxxx.php'); // New Conytribution

Now when I do it, I will insert in a alphabetically manner along with a comment with each of the new additions so that I will know what's it refer to. I guess one would say, good housekeeping.

So this should not make any difference with the addons, correct?

Thanks.

[beats]

Hi there Spooks,

Just looking for a nudge in the right direction on this and if you would be so kind to assist, I have installed your add-on and all seemed to be working (i.e i could access my site pages etc) however when I go to login into the admin section and go to the Catalog field it's blank. This leads me to believe there is something amiss with the categories php code as in your earlier post there is no room for error with PHP. MY SQL upload came back with no errors when i uploaded it so I don't believe this may be causing it or could it cause this?

Any help will be greatly appreciated.
Thanks Beats

[beats]

Hi all, I have now managed to get the catlog section to show, and if when adding new product images it gives me the option to add 3 additional images for the Simple Image Add-on, So all appeared to be well until I uploaded additional images and then clicked preview within the catalog section. I was then presented with this bit of code showing up at the botton and also an error code,


Additional Images:
if (isset($HTTP_GET_VARS['read']) && ($HTTP_GET_VARS['read'] == 'only')) { if (isset($HTTP_GET_VARS['origin'])) { $pos_params = strpos($HTTP_GET_VARS['origin'], '?', 0); if ($pos_params != false) { $back_url = substr($HTTP_GET_VARS['origin'], 0, $pos_params); $back_url_params = substr($HTTP_GET_VARS['origin'], $pos_params + 1); } else { $back_url = $HTTP_GET_VARS['origin']; $back_url_params = ''; } } else { $back_url = FILENAME_CATEGORIES; $back_url_params = 'cPath=' . $cPath . '&pID=' . $pInfo->products_id; } ?>

Then

This error

Error!

Unable to determine the page link!

Function used:

tep_href_link('', '', 'NONSSL')


I have been scouring the forums and the net for the past few days and the above error code seem fairly common however I have been unable to resolve my issue.

Can anybody help?

Thanks

[FIMBLE]

beats, on 15 June 2010, 17:14, said:

Hi all, I have now managed to get the catlog section to show, and if when adding new product images it gives me the option to add 3 additional images for the Simple Image Add-on, So all appeared to be well until I uploaded additional images and then clicked preview within the catalog section. I was then presented with this bit of code showing up at the botton and also an error code,


Additional Images:
if (isset($HTTP_GET_VARS['read']) && ($HTTP_GET_VARS['read'] == 'only')) { if (isset($HTTP_GET_VARS['origin'])) { $pos_params = strpos($HTTP_GET_VARS['origin'], '?', 0); if ($pos_params != false) { $back_url = substr($HTTP_GET_VARS['origin'], 0, $pos_params); $back_url_params = substr($HTTP_GET_VARS['origin'], $pos_params + 1); } else { $back_url = $HTTP_GET_VARS['origin']; $back_url_params = ''; } } else { $back_url = FILENAME_CATEGORIES; $back_url_params = 'cPath=' . $cPath . '&pID=' . $pInfo->products_id; } ?>

Then

This error

Error!

Unable to determine the page link!

Function used:

tep_href_link('', '', 'NONSSL')


I have been scouring the forums and the net for the past few days and the above error code seem fairly common however I have been unable to resolve my issue.

Can anybody help?

Thanks

This will happen if you place the code no opening <?php as the borwser will not know that it is server script and will trreat it as text to be displayed.
Nic

[wilhilton205]

Hi All,

I am getting this error when running the Sql query. Can anyone tell me what I missed?

Error
SQL query:

('Display Product Options', 'PRODUCT_LIST_OPTIONS', '0', 'Do you want to display product options within the product listing', 8, 0, NULL, now(), '', ''), ('Product Listing Style', 'PRODUCT_THUMBNAIL_VIEW', 'thumbnails', 'Product Listing As Thumbnails, Product List or Manufacturer List. Straight or block list.', 8, 15, NULL, now(), NULL, 'tep_cfg_select_option(array(\'list\', \'list in blocks\', \'thumbnails\', \'thumbnails in grid\', \'manufacturer\', \'manufacturer in blocks\'),'), ('Product Listing Short Description', 'PRODUCT_SHORT_DESC', 'false', 'Display Product Short Description In Listing', 8, 16, NULL, now(), NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'), ('Product Listing Buy Now / Details Button', 'LISTING_BUTTON', 'buy now', 'Display a ‘Buy Now’, ‘Details’ Button or Both', 8, 22, NULL, now(), NULL, 'tep_cfg_select_option(array(\'none\', \'buy now\', \'small buy now\', \'details\', \'buy now & details\'),'), ('Product Listing Man[...]

MySQL said:

#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 ''Display Product Options', 'PRODUCT_LIST_OPTIONS', '0', 'Do you want to display ' at line 1

[pdcelec]

wilhilton205, on 15 December 2010, 02:52, said:

Hi All,

I am getting this error when running the Sql query. Can anyone tell me what I missed?

Error
SQL query:

('Display Product Options', 'PRODUCT_LIST_OPTIONS', '0', 'Do you want to display product options within the product listing', 8, 0, NULL, now(), '', ''), ('Product Listing Style', 'PRODUCT_THUMBNAIL_VIEW', 'thumbnails', 'Product Listing As Thumbnails, Product List or Manufacturer List. Straight or block list.', 8, 15, NULL, now(), NULL, 'tep_cfg_select_option(array(\'list\', \'list in blocks\', \'thumbnails\', \'thumbnails in grid\', \'manufacturer\', \'manufacturer in blocks\'),'), ('Product Listing Short Description', 'PRODUCT_SHORT_DESC', 'false', 'Display Product Short Description In Listing', 8, 16, NULL, now(), NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'), ('Product Listing Buy Now / Details Button', 'LISTING_BUTTON', 'buy now', 'Display a ‘Buy Now’, ‘Details’ Button or Both', 8, 22, NULL, now(), NULL, 'tep_cfg_select_option(array(\'none\', \'buy now\', \'small buy now\', \'details\', \'buy now & details\'),'), ('Product Listing Man[...]

MySQL said:

#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 ''Display Product Options', 'PRODUCT_LIST_OPTIONS', '0', 'Do you want to display ' at line 1

You are missing part of the query. There should be something like INSERT INTO .............. at the start