Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Catagories.php


Guest

Recommended Posts

Posted

Hello

 

I edited catagories.php to get an extra feature. it diddnt work. Now i have an error check my website

www.gadget-crazy.co.uk look at the error and please tell me if you know what i have to and if you can help

 

also i havnt backed up that catagories.php but i have backed up the database i tried reinstalled the databse but diddnt help

 

Please some help thanks!

Posted
Hello

 

I edited catagories.php to get an extra feature. it diddnt work. Now i have an error check my website

www.gadget-crazy.co.uk look at the error and please tell me if you know what i have to and if you can help

 

also i havnt backed up that catagories.php but i have backed up the database i tried reinstalled the databse but diddnt help

 

Please some help thanks!

 

 

It appears you have added featured product contribution.This contribution needs ana dditional field in the data base which is used by the contrib.

 

When you did restore the data base or during some other work the additional field from your table was lost.

 

Hope this helps you.

 

Satish

Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Posted
It appears you have added featured product contribution.This contribution needs ana dditional field in the data base which is used by the contrib.

 

When you did restore the data base or during some other work the additional field from your table was lost.

 

Hope this helps you.

 

Satish

 

 

Thanks for that. but what am i meant to do?

Posted

What you need to do is look at the featured products contribution and then add the table back into the dbase using phpmyadmin or wotever you use.

 

Mark

Lifes a bitch, then you marry one, then you die!

Posted
What you need to do is look at the featured products contribution and then add the table back into the dbase using phpmyadmin or wotever you use.

 

Mark

 

 

mmmmm well im a newbie so can someone exlain in a simpler form. do i have to chang any php i can do that.

 

What tables?

Posted

someone also said to me

 

Your mySQL error on your home page is coming from a faulty install of the featured products contribution. It is easy to fix by simply installing it correctly.

 

 

how do i install it correctly?

Posted

do you have a copy of the featured products contribution, if not go to the contributions site and download it and then unzip it.

 

There should be a file with an extension of .sql

 

If not then open the install text file and look for where it says to add the featured products table to the database.

 

Do you use cpanel? If so go into your cpanel and then look for an icon entitled phpmyadmin and click it.

 

After phpmyadmin has opened (normally in a new window) you will need to select which database your store uses from the dropdown menu on the left. When all the tables have loaded in the main window in front of you you will need to look at at the top for a tab called SQL and then click it.

 

You should get a screen up with what looks like a text field now either cut and paste the sql into this field and click go or below that there is the option to browse your computer for the sql file and clicking go will insert the featured products sql.

 

Without doing it for you I can not explain it any easier.

 

Mark

Lifes a bitch, then you marry one, then you die!

Posted
do you have a copy of the featured products contribution, if not go to the contributions site and download it and then unzip it.

 

There should be a file with an extension of .sql

 

If not then open the install text file and look for where it says to add the featured products table to the database.

 

Do you use cpanel? If so go into your cpanel and then look for an icon entitled phpmyadmin and click it.

 

After phpmyadmin has opened (normally in a new window) you will need to select which database your store uses from the dropdown menu on the left. When all the tables have loaded in the main window in front of you you will need to look at at the top for a tab called SQL and then click it.

 

You should get a screen up with what looks like a text field now either cut and paste the sql into this field and click go or below that there is the option to browse your computer for the sql file and clicking go will insert the featured products sql.

 

Without doing it for you I can not explain it any easier.

 

Mark

 

 

thanks so much

 

i have done it

 

Thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

 

www.gadget-crazy.co.uk

Posted
thanks so much

 

i have done it

 

Thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

 

www.gadget-crazy.co.uk

 

all looks good but i cannot add delete modify profucts

it says

 

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

 

select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.Featured_Product, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from products p, products_description pd where p.products_id = '101' and p.products_id = pd.products_id and pd.language_id = '1'

 

[TEP STOP]

 

help please

Posted
all looks good but i cannot add delete modify profucts

it says

 

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

 

select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.Featured_Product, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from products p, products_description pd where p.products_id = '101' and p.products_id = pd.products_id and pd.language_id = '1'

 

[TEP STOP]

 

help please

 

go to the conmntrib and you will find something like alter table products add filed 'Featured_Product' now this field should be there in your table named product.Use PhpMyAdmin to access your data base and do it.Otr thru a Php Script fire an update query.

 

Satish

Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Posted
Where are you getting this error?

 

Mark

 

im getting this error when i go to catagories on my admin then i try and edit a product i get that error

Posted
go to the conmntrib and you will find something like alter table products add filed 'Featured_Product' now this field should be there in your table named product.Use PhpMyAdmin to access your data base and do it.Otr thru a Php Script fire an update query.

 

Satish

 

 

I dont get you i cannot find php mmy admin on my cpanel i ony got php my chat

 

 

 

Hosting package ecom

Shared Ip Address 207.58.134.215

Subdomains 1 / unlimited

Parked Domains 0 / -1

Addon Domains 0 / 1

Mysql databases 4 / unlimited

Postgresql Databases 0 / unlimited

Disk usage 0.07 Megabytes

SQL Disk usage 2.86 Megabytes

Disk space available 1023.93 Megabytes

Bandwidth usage 2608.54 Megabytes

Email accounts: 7 / unlimited

Email Forwaders 0

Auto-responders 0

Mailing lists: 0 / unlimited

Email filters 0

Ftp Accounts 0 / unlimited

 

General server information:

Operating system Linux

Service Status Click to View

Kernel version 2.4.20-021stab028.19.777-enterprise

Machine Type i686

Apache version 1.3.34 (Unix)

PERL version 5.8.7

Path to PERL /usr/bin/perl

Path to sendmail /usr/sbin/sendmail

Installed Perl Modules Click to View

PHP version 4.3.10

MySQL version 4.0.25-standard-log

cPanel Build 10.8.1-RELEASE 30

Theme cPanel X v2.5.0

Documentation Click to View

 

 

 

 

 

Mail

 

Webmail

 

Change Password

 

Parked Domains

 

Addon Domains

 

 

FTP Manager

 

File Manager

 

Disk usage

 

Backup

 

Password Protect Directories

 

 

Error pages

 

Subdomains

 

MySQL Databases

 

PostgreSQL Databases

 

Redirects

 

 

Frontpage Extensions

 

Web/FTP Stats

 

Raw Access Logs

 

Raw Log Manager

 

Error log

 

 

Subdomain Stats

 

Chatroom

 

PhpMyChat

 

Bulletin Board

 

Cgi Center

 

 

Scripts Library

 

Agora Shopping Cart

 

Cron jobs

 

Network Tools

 

MIME Types

 

 

Apache Handlers

 

OpenPGP

 

HotLink Protection

 

Index Manager

 

IP Deny Manager

 

 

SSL Manager

 

Statistics Software Configuration

 

Fantastico

 

thats what i have

Posted

Ok you need to look in the install file again and look for the modifications that need to be done to this file.

 

Mark

Lifes a bitch, then you marry one, then you die!

Posted
Ok you need to look in the install file again and look for the modifications that need to be done to this file.

 

Mark

 

 

where is the install file under?

Posted

it should be in the featured products contribution, it may also be called readme

 

Mark

Lifes a bitch, then you marry one, then you die!

Posted
it should be in the featured products contribution, it may also be called readme

 

Mark

 

 

thanks mates

 

thats done but now when i try and edit the error is gone but the editing tools are not there

 

i cannot go to the pictures on the server i cant view in external browser the editing tools are not there font size etc...

 

help again

lol

Posted

sounds like you had one of the wysiwyg contribs installed, without knowing which one I could not advise.

 

Mark

Lifes a bitch, then you marry one, then you die!

Posted
sounds like you had one of the wysiwyg contribs installed, without knowing which one I could not advise.

 

Mark

 

 

i did not install any wywiswyg

Posted

it seems to be in html and not text does that help

 

here is the details in the editor The psp Value pack comes with 32mb memory, Case, Handstrap, Headphones with remote and the psp and a FREE CLEANING CLOTH. The psp also comes with 12 month warrenty.

<P> The psp is a Asian model with 2.0 Firmware. Which means now you have access to the internet on your PSP!!!!!!!!!!!!</P>

<P>If you would like diferent firmware please tell us after purchsase. and we will upgrade/downgrae for no extra charge</P>

<P>Best model of psp out.</P>

<P>Jap/Asian psp have a bettter screen than the US psp. </P>

<P> </P>

<P>You also Get entered in the Gadget-Crazy prize draw where you can win </P>

<P>1. An Xbox 360</P>

<P>2. A PSP</P>

<P>3. A 1gb memory stick Duo</P>

<P> </P>

<P>

<TABLE id=Table1 cellSpacing=0 cellPadding=0 width=576 border=0>

<TBODY>

<TR>

<TD colSpan=2><IMG id=title-margin height=13 alt="Technical Specs" src="http://fp.scea.com/Content/consoles/4/info/img/technical-specs.gif" width=104><BR><IMG style="MARGIN-BOTTOM: 26px" height=204 alt="" src="http://fp.scea.com/Content/consoles/4/info/img/feature.gif" width=451></TD></TR>

<TR>

<TD width=393>

<TABLE id=Table2 cellSpacing=0 cellPadding=0 width=393 border=0>

<TBODY>

<TR>

<TD class=rowGreyLeft vAlign=top>

<P><STRONG><FONT face="times new roman, times, serif">Color</FONT></STRONG></P></TD>

<TD class=rowGreyRight>

<P><FONT face="times new roman, times, serif">Black</FONT></P></TD></TR>

<TR>

<TD class=rowWhiteLeft vAlign=top>

<P><STRONG><FONT face="times new roman, times, serif">Product Code</FONT></STRONG></P></TD>

<TD class=rowWhiteRight>

<P><FONT face="times new roman, times, serif">PSP-1006K</FONT></P></TD></TR>

<TR>

<TD class=rowGreyLeft vAlign=top>

<P><STRONG><FONT face="times new roman, times, serif">Dimensions</FONT></STRONG></P></TD>

<TD class=rowGreyRight>

<P><FONT face="times new roman, times, serif">Approximately 6.7 in (W) x 2.9 in (H) x .9 in (D)</FONT></P></TD></TR>

<TR>

<TD class=rowWhiteLeft vAlign=top>

<P><STRONG><FONT face="times new roman, times, serif">Weight</FONT></STRONG></P></TD>

<TD class=rowWhiteRight>

<P><FONT face="times new roman, times, serif">Approximately 280g / .62 lbs (including battery) </FONT></P></TD></TR>

<TR>

<TD class=rowGreyLeft vAlign=top>

<P><STRONG><FONT face="times new roman, times, serif">CPU</FONT></STRONG></P></TD>

<TD class=rowGreyRight>

<P><FONT face="times new roman, times, serif">PSP CPU (System clock frequency 1 - 333MHz) </FONT></P></TD></TR>

<TR>

<TD class=rowWhiteLeft vAlign=top>

<P><STRONG><FONT face="times new roman, times, serif">Main Memory </FONT></STRONG></P></TD>

<TD class=rowWhiteRight>

<P><FONT face="times new roman, times, serif">32MB</FONT></P></TD></TR>

<TR>

<TD class=rowGreyLeft vAlign=top>

<P><STRONG><FONT face="times new roman, times, serif">Embeded DRAM </FONT></STRONG></P></TD>

<TD class=rowGreyRight>

<P><FONT face="times new roman, times, serif">4MB</FONT></P></TD></TR>

<TR>

<TD class=rowWhiteLeft vAlign=top>

<P><STRONG><FONT face="times new roman, times, serif">Display</FONT></STRONG></P></TD>

<TD class=rowWhiteRight>

<P><FONT face="times new roman, times, serif">4.3 inch, 16:9 Wide screen TFT LCD </FONT></P>

<P><FONT face="times new roman, times, serif">480 x 272 pixel, 16.77 million colors </FONT></P>

<P><FONT face="times new roman, times, serif">Maximum luminance 180 / 130 / 80cd/m2 (when using battery pack) </FONT></P>

<P><FONT face="times new roman, times, serif" size=2>Region code 3</FONT></P>

<P><FONT face="times new roman, times, serif">Maximum luminance 200 / 180 / 130 / 80cd/m2 (when using AC adaptor) </FONT></P></TD></TR>

<TR>

<TD class=rowGreyLeft vAlign=top>

<P><STRONG><FONT face="times new roman, times, serif">Sound</FONT></STRONG></P></TD>

<TD class=rowGreyRight>

<P><FONT face="times new roman, times, serif">Built-in stereo speakers </FONT></P></TD></TR>

<TR>

<TD class=rowWhiteLeft vAlign=top>

<P><STRONG><FONT face="times new roman, times, serif">Main Input/<BR>Output </FONT></STRONG></P></TD>

<TD class=rowWhiteRight>

<P><FONT face="times new roman, times, serif">IEEE 802.11b (Wi-Fi) </FONT></P>

<P><FONT face="times new roman, times, serif">USB 2.0 (mini-B) </FONT></P>

<P><FONT face="times new roman, times, serif">Memory Stick Duo?</FONT></P>

<P><FONT face="times new roman, times, serif">Infrared Port </FONT></P></TD></TR>

<TR>

<TD class=rowGreyLeft vAlign=top>

<P><STRONG><FONT face="times new roman, times, serif">Disc Drive </FONT></STRONG></P></TD>

<TD class=rowGreyRight>

<P><FONT face="times new roman, times, serif">UMD Drive (Read only) </FONT></P></TD></TR>

<TR>

<TD class=rowWhiteLeft vAlign=top>

<P><STRONG><FONT face="times new roman, times, serif">Main Connectors </FONT></STRONG></P></TD>

<TD class=rowWhiteRight>

<P><FONT face="times new roman, times, serif">Memory Stick Duo? Slot </FONT></P>

<P><FONT face="times new roman, times, serif">USB connector </FONT></P>

<P><FONT face="times new roman, times, serif">DC IN 5V connector </FONT></P>

<P><FONT face="times new roman, times, serif">Headset connector </FONT></P></TD></TR>

<TR>

<TD class=rowGreyLeft vAlign=top>

<P><STRONG><FONT face="times new roman, times, serif">Keys/Switches</FONT></STRONG></P></TD>

<TD class=rowGreyRight>

<P><FONT face="times new roman, times, serif">Directional buttons (Up/Down/Right/Left)</FONT></P>

<P><FONT face="times new roman, times, serif">Analog Stick</FONT></P>

<P><FONT face="times new roman, times, serif">Enter keys (Triangle, Circle, Cross, Square)</FONT></P>

<P><FONT face="times new roman, times, serif">Left, Right shoulder buttons x 1</FONT></P>

<P><FONT face="times new roman, times, serif">START button, SELECT button, HOME button x 1</FONT></P>

<P><FONT face="times new roman, times, serif">POWER/HOLD switch x 1</FONT></P>

<P><FONT face="times new roman, times, serif">Display button, Sound button, Volume +/- buttons x 1</FONT></P>

<P><FONT face="times new roman, times, serif">Wireless LAN switch (ON/OFF) x 1</FONT></P>

<P><FONT face="times new roman, times, serif">OPEN latch (UMD) x 1 </FONT></P></TD></TR>

<TR>

<TD class=rowWhiteLeft vAlign=top>

<P><STRONG><FONT face="times new roman, times, serif">Power</FONT></STRONG></P></TD>

<TD class=rowWhiteRight>

<P><FONT face="times new roman, times, serif">Lithium-ion Battery </FONT></P>

<P><FONT face="times new roman, times, serif">AC Adaptor </FONT></P></TD></TR>

<TR>

<TD class=rowGreyLeft vAlign=top>

<P><STRONG><FONT face="times new roman, times, serif">Profile</FONT></STRONG></P></TD>

<TD class=rowGreyRight>

<P><FONT face="times new roman, times, serif">PSP Game </FONT></P>

<P><FONT face="times new roman, times, serif">UMD Audio (profile name TBD) </FONT></P>

<P><FONT face="times new roman, times, serif">UMD Video (profile name TBD) </FONT></P></TD></TR>

<TR>

<TD class=rowWhiteLeft vAlign=top>

<P><STRONG><FONT face="times new roman, times, serif">Codec</FONT></STRONG></P></TD>

<TD class=rowWhiteRight>

<P><FONT face="times new roman, times, serif">[Video]: "UMD": H.264/MPEG-4 AVC Main Profile Level3 </FONT></P>

<P><FONT face="times new roman, times, serif">[Video]: "Memory Stick": MPEG-4 SP,AAC </FONT></P>

<P><FONT face="times new roman, times, serif">[Music]: "UMD": linear PCM,ATRAC3plus? </FONT></P>

<P><FONT face="times new roman, times, serif">[Music]: "Memory Stick": ATRAC3plus?,MP3(MPEG1/2 Layer3) </FONT></P></TD></TR>

<TR>

<TD class=rowGreyLeft vAlign=top>

<P><STRONG><FONT face="times new roman, times, serif">Security</FONT></STRONG></P></TD>

<TD class=rowGreyRight>

<P><FONT face="times new roman, times, serif">(Encryption) 128bit AES (Copyright protection technology) MagicGate? </FONT></P></TD></TR>

<TR>

<TD class=rowWhiteLeft vAlign=top>

<P><STRONG><FONT face="times new roman, times, serif">Access control </FONT></STRONG></P></TD>

<TD class=rowWhiteRight>

<P><FONT face="times new roman, times, serif">Region, Parental Control </FONT></P></TD></TR>

<TR>

<TD class=rowGreyLeft vAlign=top>

<P><FONT face="times new roman, times, serif"><STRONG>Wireless<BR>communications</STRONG><BR>IEEE802.11b </FONT></P></TD>

<TD class=rowGreyRight>

<P><FONT face="times new roman, times, serif">Infrastructure mode </FONT></P>

<P><FONT face="times new roman, times, serif">Ad hoc mode (connection up to 16 consoles) </FONT></P></TD></TR>

<TR>

<TD class=rowWhiteLeft vAlign=top>

<P><STRONG><FONT face="times new roman, times, serif">PSP Value Pack<BR>supplied<BR>accessories <BR></FONT></STRONG></P></TD>

<TD class=rowWhiteRight>

<P><FONT face="times new roman, times, serif">AC adaptor</FONT></P>

<P><FONT face="times new roman, times, serif">Battery pack</FONT></P>

<P><FONT face="times new roman, times, serif">Memory Stick Duo (32 MB)</FONT></P>

<P><FONT face="times new roman, times, serif">Headphone with remote control</FONT></P>

<P><FONT face="times new roman, times, serif">Soft case </FONT></P>

<P><FONT face="times new roman, times, serif">Free Cleaning Cloth and enters you in the prize draw. And more</FONT></P></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></P>

 

now go on my website www.gadget-crazy.co.uk and look at the psp detials its the same

whats happend

Posted

i think that i need the catagories.php redone or i need the orginal to replace it. any suggestons mark ?

Posted

ask your host to send you the file from a backup of a couple of days ago.

 

That might help.

 

Mark

Lifes a bitch, then you marry one, then you die!

Posted
ask your host to send you the file from a backup of a couple of days ago.

 

That might help.

 

Mark

 

Alright thanks for everything man!

 

What is your website?

Posted

Click the card button next to where it says 'ON'

 

Mark

Lifes a bitch, then you marry one, then you die!

Archived

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

×
×
  • Create New...