Guest Posted February 27, 2006 Posted February 27, 2006 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!
satish Posted February 27, 2006 Posted February 27, 2006 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.
Guest Posted February 27, 2006 Posted February 27, 2006 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?
mark27uk3 Posted February 27, 2006 Posted February 27, 2006 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!
Guest Posted February 27, 2006 Posted February 27, 2006 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?
Guest Posted February 27, 2006 Posted February 27, 2006 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?
mark27uk3 Posted February 27, 2006 Posted February 27, 2006 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!
Guest Posted February 27, 2006 Posted February 27, 2006 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
Guest Posted February 27, 2006 Posted February 27, 2006 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
satish Posted February 27, 2006 Posted February 27, 2006 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.
mark27uk3 Posted February 27, 2006 Posted February 27, 2006 Where are you getting this error? Mark Lifes a bitch, then you marry one, then you die!
Guest Posted February 27, 2006 Posted February 27, 2006 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
Guest Posted February 27, 2006 Posted February 27, 2006 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
mark27uk3 Posted February 27, 2006 Posted February 27, 2006 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!
Guest Posted February 27, 2006 Posted February 27, 2006 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?
mark27uk3 Posted February 27, 2006 Posted February 27, 2006 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!
Guest Posted February 27, 2006 Posted February 27, 2006 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
mark27uk3 Posted February 27, 2006 Posted February 27, 2006 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!
Guest Posted February 27, 2006 Posted February 27, 2006 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
Guest Posted February 27, 2006 Posted February 27, 2006 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
Guest Posted February 27, 2006 Posted February 27, 2006 i think that i need the catagories.php redone or i need the orginal to replace it. any suggestons mark ?
mark27uk3 Posted February 27, 2006 Posted February 27, 2006 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!
Guest Posted February 27, 2006 Posted February 27, 2006 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?
mark27uk3 Posted February 27, 2006 Posted February 27, 2006 Click the card button next to where it says 'ON' Mark Lifes a bitch, then you marry one, then you die!
Recommended Posts
Archived
This topic is now archived and is closed to further replies.