Jump to content



Member Since 29 Nov 2008
Offline Last Active Jun 30 2014 09:12 PM

Topics I've Started

db_query INSERT issues...

03 April 2013 - 06:28 PM

So I'm trying to do a simple insert but for some reason I keep getting an error and all the fields in my array check out. Do I need to provide value pairs for every field?

When I try to run this simple code:

$shipment_load = array(
  "shipping_id" => $record_unser[6]["shipping"],
  "carrier" => $record_unser[6]["carrier"],
  "tracking_number" => $record_unser[6]["tracking_number"],
  "timestamp" => $srkey["timestamp"]+(60*60*24),
  "comment" => ""
$shipment_load_id = db_query("INSERT into ?:shipments ?e", $shipment_load);

I get the following error:

Database error: Table 'cscart.cscart_' doesn't exist (1146)
Invalid query: SHOW COLUMNS FROM cscart_

I don't understand why the table to insert is disappearing during the course of the query. I can insert non-variable values that are appropriately typed and nothing seems to work. Is the format for this different in 2.2.5?

Class includes for addons...

25 March 2013 - 04:57 AM

Hey folks,

So I'm working on a fairly complex Amazon integration and I am trying to establish the best place to put classes - I'd like to keep them separate in the addon because ultimately when they roll out API updates and update their models I'd like to be able to update them fairly easily.

However I am not entirely sure where/how to implement autoloading in 2.2.5 - the docs indicate that autoloading is already a feature in 3.0.x and that you simply need in include the classes you want in the 'core' subdirectory of the addon and name them class.ClassName.php - but for the 2.2.x what is the best way to set up an autoloader pull classes and where is that done from?

My gut says func.php and so I will try that tomorrow, but I hope another dev can share some experiences on pulling external class libraries into an add-on in a clean and nonobtrusive way.

Thanks in advance!

Multi-vendor - more than one vendor per product - thoughts?

22 May 2012 - 05:15 PM


I posted this in the ideas section but wanted to drum up some support and feedback for it.

I was very excited about the multi-vendor capabilities because we presently offer an affiliate program for parish bookstores but have been looking to do something more. In particular, we wanted to provide folks with local options for purchasing items in their area where they exist.

So for example, a parish could list products in their tiny bookstore and their price and you would effectively have an amazon marketplace style selling platform. This would allow our catalog to expand in ways that we might not expect, provide analytics on products we might not otherwise see demand for, allow print on demand folks to have their work given a trial run etc.

Another option - what if you have an online store and many physical store locations? Wouldn't it be great to be able to have your customer request certain items for pick-up locally? Multi-vendor would be great for this is you could set up a vendor account for each location and then, once again, let the customer choose the vendor (in this case the location) for the product.

This choice could easily be integrated into the product options section - even allowing for price modifiers, etc. You could list it as a table with a radio button, etc.

Thoughts? Is this not how you would expect Multi-vendor to work? Don't get me wrong, if I was still running a drop-shipment enterprise the multi-vendor as it stands now is awesome - we sure could have used it back in 2006. But this seems like a really innovative application that doesn't seem like it would take a lot of development time.