...)When Sharon from Miami does workout with the Miami girls she does enjoy it very much. (topic: enjoys doing workout) 4.)On Saturdays Sharon likes to drive around Miami to visit all her Miami girls. (topic: likes to drive around) and so on... You see, each sentence contains the given keywords, but describes a different topic / scene. IMPORTANT: ALL sentences must be in form of a "clause of statement", written in "present progressive" or "simpel present" from a 3rd persons view. No "future" and no "past" sentences! If you don't understand this, please don't bid. The 50 sentences for one set of keywords should be together about 500 - 600 words. 5 sets with each 50 sentences would then be around 2,500 - 3,000 w...
...)When Sharon from Miami does workout with the Miami girls she does enjoy it very much. (topic: enjoys doing workout) 4.)On Saturdays Sharon likes to drive around Miami to visit all her Miami girls. (topic: likes to drive around) and so on... You see, each sentence contains the given keywords, but describes a different topic / scene. IMPORTANT: ALL sentences must be in form of a "clause of statement", written in "present progressive" or "simpel present" from a 3rd persons view. No "future" and no "past" sentences! If you don't understand this, please don't bid. The 50 sentences for one set of keywords should be together about 500 - 600 words. 5 sets with each 50 sentences would then be around 2,500 - 3,000...
PHP5 CLI cURL class Deliverables: 1. PHP Class, detailed functionality in the accompanying attac...or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. * * *This broadcast message was sent to all bidders on Sunday Jun 15, 2008 2:28:03 AM: 1. The release of this bid request included the RAC boiler plate text (Clause 3) about not accepting a solution based on Open Source Software/GPL etc. The clause has been deleted from the bid request. It is assumed that the solution will make use of php_curl. If you have a solution based on some other library, please make this clear. ## Platform LAMP, WAMP, Linux command line, Windows comma...
... Issues: - possible php5 compatibility issue. Recently when the server was updated to php5 - the order emails received by admin are now missing lots of information, namely: Delivery address, billing address & payment method --------------------------- Client: C Issues: - php5 compatibility. Clicking on a product category results in error: "1054 - Unknown column 'p.products_id' in 'on clause' select distinct p.products_id, p.products_image, p.products_tax_class_id, as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c left join featured f on p.products_id = f.products_id where p.products_id = p2c.product...
Apparently there is a known issue with MySQl 5 and it has broken our site. The error is as follows: 1054 - Unknown column 'p.products_id' in 'on clause' select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials_retail_prices s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '4' [TEP STOP] This error didn't crop up until our service provider upgraded to MYSQL 5.
I can’t set the definer clause because SqlYog Community 6.54 considers it a comment instead of actual syntax.. Even after I change it manually it just reappear as a comment any idea how I can fix this. Please review my attachment for screen shot.. Thank you I will accept the first bid that provides a real solution.. not the first bid who claims they can fix it. Here is link to syqlyog ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended
...Sin(lat2)) + ((lat1) * (lat2) * (lon2 - lon1))); int idistance = (int) (distance * 3963); return idistance; } Note that longitudes and latitudes must be in radians. To use this to grab everything with a certain radius straight from the database, you can do something like (this was in SQL Server 2K so you can't use aliases in the WHERE clause): SELECT , , , ROUND( (ACOS( (SIN() * SIN()) + (COS() * COS() * COS( - )) ) ) * 3963,1 ) AS distance FROM Airports a, Cities c WHERE ( ACOS( (SIN() * SIN()) +
A simple job for an SQL expert.... I want to create a VIEW with SQL and my problem is that it does not return any values. I think it needs to be different, becuase one of the statements in WHERE clause = does not always have records in table2.field2. Actually there is no record in table2. I think it needs to be done with OUTER JOIN, etc.... Who can help me? ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the
Hi I have created a user login for my site, but i need someone to create a session with the login details (email) and provide me with the session variable name (email) for a sql query, the session variable will be required for the "where" clause in the query. also i need the coder to make one of my fields in the reg form a upload field. the field should allow .doc files to be uploaded. relatively simple for a good coder.
We need some one to fix an mysql php4.0 error on our search pages in Oscommerce. We switched from hosting providers from php 5 to php 4 and now it does not work. The main page search and admin product catalog search both display the error. 1054 - Unknown column 'ordenabase.p2pef.manufacturers_id' in 'on clause' select count(distinct p.products_id) as total from (products p left join products_to_products_extra_fields p2pef on p.products_id=p2pef.products_id) left join manufacturers m using(manufacturers_id) left join specials s on p.products_id = s.products_id, products_description pd, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '3' and p.products_i...
...having 2 issues with my oscommerce store. It seems when the host server did some upgrades is when my site went hay-wired. Upgrades included the installation of new php / sql. The website (oscommerce stie) in question is located at ISSUE #1 If you click on the side links, under catergories viewers see this message... **1054 - Unknown column 'p.products_id' in 'on clause' select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_i...
receiving an error in our osCommerce site The error in the store is: 1054 - Unknown column 'p.products_id' in 'on clause' select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '31' This shows up when you click on the left in "catagories"
Hi there, mysql has been updated and caused some problems to my oscommerce website, I am getting an error when I try to click on a product: 1054 - Unknown column 'p.products_id' in 'on clause' select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '49' [TEP STOP] The oscommerce script is heavily modified, so a simple replace can not be done. Apparently there are patches and fixes avaialble. ...
"1054 - Unknown column" problem on Oscommerce.. It comes up when I try and update or add a file to the product attributes..
... Define a query that uses the Natural Join command to join three tables. 2. Define a query that uses the traditional join method (the one that use the WHERE clause to specify the key and foreign equal) to join two or three tables. 3. Define a query to perform an Outer Join. It is your choice to do a Full, Left, or Right Outer. 4. Define a query that uses the Union operator to retrieve some useful information. 5. Define a query that uses the Intersect operator to retrieve some useful information. 6. Define a query that computes subtotals from the results of a join operation. 7. Define a query that uses the HAVING clause to check the subtotals. 8. Define a query with a subquery. 9. Define a query that uses the IN (or NOT IN) to check keys returned by a su...
? I need help creating an UPDATE statement that involves at least two tables and will be using a GROUP BY clause. MS SQL 2000 Should not be difficult if someone know what they are doing. ## Deliverables ? HELLO? MS SQL DATABASE coders ? I need help creating a single UPDATE statement. ? I have been poking around with it , but cant get it to work properly. ? It is just 2 tables with Joins and a Group By condition ? If you are very comfortable with? MS SQL? could you please take a look into my request.. My guess is an hour or two? --- only 1 statement needs to be coded Thanks ? * * *This broadcast message was sent to all bidders on Tuesday May 6, 2008 6:02:53 PM: Looking to have this completed by May 7th 3:00 PM EST .....
A simple cut and paste Job from PDF to excel is required. My conditions are two - 1. You should be a team. The quantity demands that. 2. The deliverables are to be given daily else there is a discount clause. I require a minimum 1000 entries per day from the pdf. If the delivery is not done, no payment adn a bad rating as well. All payment after the project ends. Bonus clause there. If the first project goes well, I have an entire library to convert. Professionals ONLY. No time wasters. And NO description of what you can do in the cyber world. Answer to my questions and we have a deal. I need to start tomorrow on a trial basis. Will be selecting more than one provider if required. Regards and happy bidding.
Hey, I believe an mysql update has created an error for one of our queries, We are getting this error message: 1054 - Unknown column 's.cat_id' in 'on clause' select count(*) as total from products p, featured s, products_description pd left join fcat f on = s.cat_id where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id I have attached the file.
...any re-validation links emailed to them and they cannot receive payments. This means the script will need to look at the 5 people above someone who are not in Vacation mode to make sure 5 people get paid when someone purchases an ad. I will need a mass payment feature to do batch payments for any withdrawal requests. I'm also concerned about spam complaints. In each email ad that goes out a clause and link should be included. Such as If you no longer wish to receive email ads from BUSINESS NAME please use the link below to terminate your membership. If you have any ideas on preventative measures to keep my hosting service from shutting me down with 1 or 2 spam complaints, I would like your input. Perhaps a rotating IP address option? Or sending ads from a different dom...
Hello, I need the following. I have an ebay affiliate account. I need to run specific rss feeds from that account that include my ebay affiliate tracking code in t...Price (fixed price 'buy now' ads only. Location (state) Ad title Ad contents Ad image URL URL (as mentioned before) I would like examples of your previous work. I would also like you to use 'onemore' in your post so I know you are not a bot. I will provide the .csv file format needed to do this. Finally, bidding on this project will constitute your agreement of a confidentiality clause. No information I provide during this project will be provided to anyone but the individual I am working with. Payment will be provided after the project is finished to my satisfaction. Than...
My hosting provider did some server updates so my website has this error on frontpage. 1054 - Unknown column 'p.products_id' in 'on clause' Already worked on code in and but error is still there. Need help!
Overview: VBScript (JScript/Powershell?) routine to build a file system directory structure on a network server based on details queried from an ODBC database source. Detail: Key sys...relevant field names and values as a popup except it only seems to return the results for a single record - presumably somehow you need to scroll through the records but that's beyond my knowledge of ADODB. The SQL query above returns the two relevant fields BUSINESSENTITY and COMPANYNAME in the correct format. It also returns the LAST_MODIFIED_DATE, but obviously we need to change the WHERE clause to only return those where the LAST_MODIFIED_DATE is > then the last time the routine was run. No need to worry about changes of company names / deletions of customer records or any ot...
We need an internal system that can measure the quantity and identity of music downloads through limewire and emule. We need to work with you to identify exactly how to do this so we can continually monitor traffic on these networks and extract this data into our database. The file information we want to collect is: File name ...specific 24hr period, AND be able to show us how you gathered this information. Please ignore the scriptlance programming options/database options check boxes that we checked for this project. Your methods can be whatever you think is necessary to accomplish the goal. Non-disclosure agreement signature required before project start. Non-compete clause and we would own ALL rights to software and solutions.
Hi <> X-Cart Pro 4.0 - newer PHP5/MySQL5 versions - compatibilty issues The SQL QUERY FAILURE errors I'm seeing on all of the pages This errors Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/hobbyou/public_html/store/include/ on line 102 INVALID SQL: 1054 : Unknown column '' in 'on clause' SQL QUERY FAILURE: SELECT , , , , MIN() AS price, , IF - "An More info" Now will it cost to fix this if it can be. Or upgrade to the newer versions of X-Cart with all of items in the old X-Cart added to the new X-Cart? Thanks any information
...programmers of the system before they decided to stop communication with us. This is what this job consists of but as said earlier there will be many more jobs and changes in the future: **Front End Issues:** -When adding to cart there can be a problem where a plain white page is displayed or a sql error saying ??" select * from ccs_accessory where id=none ----Unknown column??none?? in??where clause??. This sql error can also be caused from loading a saved quote and then clicking on the accessories and software step that is highlighted blue. -The fact I am seeing a sql error is not good as front end users should see a more user friendly page that is the same template as the rest of the site with the sql error. The sql error needs to be shown so that if errors happ...
Hello, has a project to check and update 2 databases (around 3500 records). Someone will have to look for missing websites, emails, telephone numbers etc. Both spreadsheets need to be organized and consistent. There is also a possibility of changing these spreadsheets into XML files. We a...a project to check and update 2 databases (around 3500 records). Someone will have to look for missing websites, emails, telephone numbers etc. Both spreadsheets need to be organized and consistent. There is also a possibility of changing these spreadsheets into XML files. We are looking for someone who is detail oriented. Keep in mind that this job is covered by the strict confidentiality clause - the materials will be available only to one person or firm. THis is very important.
We have upgraded Sugar Community Version 4.5.1 to 5.0.0b and have followed the upgrade instruction according to the following URL: We have done all of the following: -->Ensure post_max_size is set to m...large number or use the default value of 2GB. Restart Apache and then begin the upgrade process. -----------> Uploaded the upgrade files over the old files via SFTP. We are getting the following error when we login to where Sugar is installed: Query Failed:SELECT tracker.* from tracker WHERE user_id = '1' AND visible = 1 ORDER BY id DESC LIMIT 0,10::MySQL error 1054: Unknown column 'visible' in 'where clause' Did we miss something? We need someone that is experienced in Sugar to help us resolve this problem.
Finishing a Multi-Stores installation on a OSCMAX (OSCommerce) working store. Mainly SQL queries, everything else is about done. A few SQL queries need to be fixed to work on a MySQL 5 server (1054 error, () needed on joins?) and a few more files need their SQL query changed to include the Multi-Store changes (so products available on store A but not active on store B will not be viewed on store B). ## Deliverables Running a live store at with OSCMAX , and now I have installed on it Multi-Stores in order to have several stores running on the same OSC database. The test store has been set up on and seems to be working ok with the following glitches. Note that store template is not /templates/fallback , but I prefer to have the
...of the first page on I need this feature. When you use it, a second page opens and the customer inputs there contact info.I need to capture this info in an user friendly data base and respond to the request by auto-responders email system. 4.I need a icon for "bad credit"and for regular customers to fill out a credit application in a secure area. 5.I need a privacy clause 6.I need to communicate may service clearly and compellingly 7.I need a sign up page for auto dealers 8.I need a bbb icon "better business bureau. 9.I would like to put all the automakers links 10.I need project done in 7-10 days and need tech-support after for a few week to work out bugs and changes.I own all intellectual-property and a NDC signed. 11
...works on all sites Enlarge does not and Mo Pics not working we do have SSH access just don't have the time to complete. Specials are showing the correct price based on selection of stores i. Should so the current price from that website show the discount Fix the few Errors "and any new ones you make ;)": Like getting error below: 1054 - Unknown column 'p.products_id' in 'on clause' select count(*) as total from products p left join manufacturers m on (p.manufacturers_id = m.manufacturers_id), products_description pd INNER JOIN products_to_stores p2s ON p.products_id = p2s.products_id where p2s.stores_id = '1' and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1'...
Please read the entire post before quoting: 1. Have New Products show under their respective category and the home page. 2. In admin under Reports - Recover Cart Sales, it is not working. It has this error message: 1054 - Unknown column 'RCS_PENDING_SALE_STATUS' in 'where clause' select o.orders_id, o.customers_id, o.date_purchased, s.orders_status_name, as order_total, from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where (o.customers_id = 657 OR o.customers_email_address like "" OR o.customers_name like "Marisa Knight") and o.orders_status > RCS_PENDING_SALE_STATUS and s.orders_status_id = o.orders_status and o.date_purchased >= "20070423" and = "ot_total&...
...works on all sites Enlarge does not and Mo Pics not working we do have SSH access just don't have the time to complete. Specials are showing the correct price based on selection of stores i. Should so the current price from that website show the discount Fix the few Errors "and any new ones you make ;)": Like getting error below: 1054 - Unknown column 'p.products_id' in 'on clause' select count(*) as total from products p left join manufacturers m on (p.manufacturers_id = m.manufacturers_id), products_description pd INNER JOIN products_to_stores p2s ON p.products_id = p2s.products_id where p2s.stores_id = '1' and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1...
...Ministry Name > Description, Image, Links This is to show the page flow. We would like some references. Any suggestions are appreciated. Thank You, Marc and Kemella Allyn ## Deliverables The feel of the Website is important. this is often expressed with images and graphics. All graphics and images need to be approved before project is finaized. I would also like to have a performance clause to specify any programming errors discovered will be repaired at no cost. We shoul have a 3 step finale acceptance for small changes to be made at no cost. I would also like to know a future per hour charge for additional programming. We can communicate by Skype in the mornings. This is a website my wife and I are purchasing to help others in Christs name. If you have a pass...
...from customers order by name" * Action filter should obtain customer list with SQL query "select distinct action from log_table order by action" * Priority filter should contain set of inclusive priority levels, as LOG_EMERG, LOG_ALERT+higher, LOG_CRIT+higher, ..., LOG_INFO+higher, ALL - by default ALL (no filtering) * IP filter should be simple textfield passed to SQL to "ip like pattern" clause, but only if it's not empty (by default it's empty, no filtering) * Message filter - same as IP filter * Filter values should be saved between succesive page views, but saving values between sessions is not necessary * Filter engine should follow basic security constraints, i.e. by using prepared queries. However, passed variables (i.e. cust...
...? ? ? ? ? | ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? (c)? ? ? ? ? ? ? (b) Figure 1: Graphical representation of parse tree for ~a=>(b<=>c&b|1) 1.3 CNF Any wff can be transformed into a CNF. A CNF is a conjunction of disjunctive clauses, defined as follows: ² A literal is a variable, a constant or the negation of a variable or a constant ² A disjunctive clause is a disjunction of literals, e.g: a | b | ~c | ~1 (Note that a clause may contain a single literal.) ² A CNF is a conjunction of disjunctive clauses, e.g: (a | b | ~c) & ~b & ~e CNF that contain constants can be simpli¯ed. Deliverables 1-? ? ? ? lex program 2-? ? ? ? yacc program 3-? ? ? ? tree.c 4-? ? ? ? make file...
Hello, please see website When you click on add to cart, the shopping cart is still empty. Also, got error when i click on item in menu: 1054 - Unknown column 'p.products_id' in 'on clause' select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '61' Thanks ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliv...
Hello, We setuped a new template on Lowest bidder welcome. Few bugs need to be fixed: - Shopping card - Specials page - FAQ **1054 - Unknown column 'p.products_id' in 'on clause' select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '61' [TEP STOP]** ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code o...
I have a problem showing at my site and every other subcategory page, no products seem to be showing. 1054 - Unknown column 'p.products_id' in 'on clause' select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '64' [TEP STOP] If I receive a good price for this work, I will use you whenever I need programming done, We have just started our web design business and require someone reliable and cos...
I'm creating a web store. Recently I've installed a new template and since the template was installed I can no longer create a visitors account and nobody can log into my site with their log in information. On the front end I get the following message 1054 - Unknown column 'member_level' in 'field list' select customers_id, customers_firstname, customers_password, customers_email_address, customers_default_address_id, member_level from customers where customers_email_address = '' [TEP STOP] I'm also getting the following on my backend 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 '-20, 20' at line 1 select o.orders_i...
I need a legal documetn writer, to write me a Non disclosure and Non circumvention agreement, Which ties my freelance and outsourced workers in so that they can't go round me, or in any way harm my business, I need some sort of penalty clause so that if they do it costs them. This is aimed at uk freelancers and businesses, so need to adhere to UK Law, and relly tie them in. I need it so that i can chage the names at the top, and it works for a new company. ## Deliverables Must Provide Word Doc Template, And laymans explanation of terms used within document. I think this would be a minimum 10 page document ( I need it to take reader abit of time to read through
...any re-validation links emailed to them and they cannot receive payments. This means the script will need to look at the 5 people above someone who are not in Vacation mode to make sure 5 people get paid when someone purchases an ad. I will need a mass payment feature to do batch payments for any withdrawal requests. I'm also concerned about spam complaints. In each email ad that goes out a clause and link should be included. Such as If you no longer wish to receive email ads from BUSINESS NAME please use the link below to terminate your membership. If you have any ideas on preventative measures to keep my hosting service from shutting me down with 1 or 2 spam complaints, I would like your input. Perhaps a rotating IP address option? Or sending ads from a different dom...
...? ? ? ? ? | ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? (c)? ? ? ? ? ? ? (b) Figure 1: Graphical representation of parse tree for ~a=>(b<=>c&b|1) 1.3 CNF Any wff can be transformed into a CNF. A CNF is a conjunction of disjunctive clauses, defined as follows: ² A literal is a variable, a constant or the negation of a variable or a constant ² A disjunctive clause is a disjunction of literals, e.g: a | b | ~c | ~1 (Note that a clause may contain a single literal.) ² A CNF is a conjunction of disjunctive clauses, e.g: (a | b | ~c) & ~b & ~e CNF that contain constants can be simpli¯ed. Deliverables 1-? ? ? ? lex program 2-? ? ? ? yacc program 3-? ? ? ? tree.c 4-? ? ? ? make file...
hey guys i switched my site to new web hosting provider and after i have uploaded teh site to new host. i was getting this error when i visit product category page 1054 - Unknown column 'p.products_id' in 'on clause' select distinct p.products_id, p.products_image, p.products_tax_class_id, as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c left join featured f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '5' and p.products_status = '1' and = '1' order by rand() DESC limit 6 [TEP STOP] olny two things i could th...
I am getting error in my site due to server php upgrade i suppose. My site is here. I have found solution to problem on forum which is here. ;hl=1054+unknown+column Exact work required as per forum above is here. Can you please perform above steps for me. Please quote.
I purchased a multiple membership script and everything works fine except that I cannot edit the contents of the table that includes the html for my front pages. Everytime I try to change the content of the pages via the script - nothing happens - and nothing is changed. I usually go into the mysql database and edit the table contents to reflect my html but my work around is not work...table contents to reflect my html but my work around is not working on this particular script. I keep getting this error when I try to do? anything related? to the ? table and its contents & quite simply I need an experienced coder to go in and fix the problem: Error SQL-query :? SELECT * FROM `affiliate_pages` WHERE `note` LIKE 0x MySQL said: Unknown column '0x' ...
1054 Unknown column 'p.products_id' in 'on clause' and other errors may follow, if we get past this one. I have done extensive customization on my Zen cart and would like a simpler fix than migrating to Zen cart 1.3x
Require a Person to remedy 1054 error on checkout and install & configure 2 shipping modules
