Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

mysterylectric

Members
  • Content count

    10
  • Joined

  • Last visited

Profile Information

  • Real Name
    m brian ladner
  • Gender
    Male
  • Location
    Southern California
  1. mysterylectric

    Easy Populate & Products Attributes

    and one more question, and i apologize in advance as i'm guessing there is probably a better forum to ask this in, but does anyone have a visual schematic diagram of the mysql database schema for the standard osCommerce 2.2 Milestone 2 Update 060817 database - one showing the relationships between the tables (something like ERwin used to do, but cheaper)? if not, does anyone know of a tool that will do that given the database? if not, any pointers as to where i should be looking? thanx m brian ladner
  2. mysterylectric

    Easy Populate & Products Attributes

    New question: Now that i found the help necessary to make easypopulate work with php5 with the minor code change listed above (to solve the problem of only one record being inserted into the database at a time), i have a scarier question: has anyone else run into any major problems using easypopulate with attributes (mine were simple entries including at most category information) or any other heavily used contribution with php5? thanx m brian ladner
  3. mysterylectric

    Easy Populate & Products Attributes

    you nailed it on the head, which i did again and again as it sounds like you did a while back. i searched through pages and pages of search results on "+easypopulate +php5" and finally found the following: I decided dig thru the 200+ pages of answers in this thread and I found the answer to my problem listed above. Just to reiterate, here's what choosealogin suggested: First check to see what version of PHP 5 you are running. If you're not sure, go to admin > tools > server info ...php version # will be at the top. I suspect it's PHP5. IF THAT IS THE CASE, In your easypopulate.php file Find array_walk($readed, 'walk'); replace with this //array_walk($readed, 'walk'); foreach ($readed as $readed_record) { walk($readed_record); } If it's NOT php5, don't change anything at this point. Thanks, choosealogin! thanks to both of you - you turned two weeks of banging my head into a wall into two days - not a bad improvement!!! brian ladner
  4. mysterylectric

    Easy Populate & Products Attributes

    true it seems - i have searched back through this forum and see multiple references to problems using easypopulate with php5. most who could claimed that they backed down to php 4 and it worked fine. I backed down to php 4.4.5 (with apache 2.0.54, mysql 5.x) and ran into new problems. it seems easypopulate worked ONCE, then when i went to look at the catalog, i'd get a blank page, with the following in the apache error_log. [Thu Feb 15 00:31:47 2007] [notice] child pid 23509 exit signal Bus error (10) so i built the latest apache (2.2.4), then built php 4.4.5 using its headers/libraries (as well as the same mysql libraries), and ran immediately into [Thu Feb 15 00:28:44 2007] [notice] Apache/2.0.54 (Unix) PHP/4.4.5 configured -- resuming normal operations [Thu Feb 15 00:31:47 2007] [notice] child pid 23509 exit signal Bus error (10) [Thu Feb 15 00:31:48 2007] [notice] child pid 23483 exit signal Bus error (10) [Thu Feb 15 00:31:49 2007] [notice] child pid 23510 exit signal Bus error (10) [Thu Feb 15 00:34:19 2007] [notice] child pid 23496 exit signal Bus error (10) [Thu Feb 15 00:34:20 2007] [notice] child pid 23497 exit signal Bus error (10) [Thu Feb 15 00:34:22 2007] [notice] child pid 23484 exit signal Bus error (10) if i'd swap back out libphp5.so for libphp4.so (each having its own php.ini file and binary, of course) and restart, and the /catalog/ and /admin/ sections worked fine, but easy populate wouldn't load more than one record again. again, i'm doing all this using a mac: # uname -a Darwin localhost 7.9.0 Darwin Kernel Version 7.9.0: Wed Mar 30 20:11:17 PST 2005; root:xnu/xnu-517.12.7.obj~1/RELEASE_PPC Power Macintosh powerpc does anyone know a combo of apache and php versions that should work for both the oscommerce package AND easypopulate? or does someone have another solution? i can keep trying combos till the cows come home i guess, but i'm sure i'm not the first to run into this problem... i wish i were so unique :rolleyes: thanx in advance brian ladner
  5. mysterylectric

    Easy Populate & Products Attributes

    i have a fear you're probably right, and my php4 to php5 conversion skills aren't all that i would hope they would be. any idea on how to refine the search beyond PHP5? thanx brian ladner
  6. mysterylectric

    Easy Populate & Products Attributes

    quick addition - i tried using the "upload and insert" method from my pc at home and received the same results. thanx brian ladner
  7. mysterylectric

    Easy Populate & Products Attributes

    I am hoping someone can help me through what should be a fairly simple problem - just not one i can find by scouring the docs, the forums, and the contributions related to Easy Populate. I have setup osCommerce 2.2 Milestone 2 Update 060817 on a Mac/*nix (Kernel Version 7.9.0) and have it running with no major problems so far. I downloaded and setup EP_v2_76d_MS2, read the documentation, made all the configuration changes, and then created a couple of simple tab-delimited text files to insert into the database and placed them in the /catalog/temp/ directory. The first row/line contained the fieldnames as described in the documentation that came with EP that I needed, followed by an EOREOR. The next three rows contained the values for those fields i wanted inserted into the database. I was very careful to put an EOREOR at the end of each row/line and make sure that v_products_model is unique. Here is one example (and i made sure that all fields were tab-delimited): v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_price v_products_weight v_products_quantity v_categories_name_1 v_categories_name_2 v_categories_name_3 v_date_added v_date_avail v_tax_class_id v_status EOREOR BB001WG BB001WG.gif White Gold Bracelet This is a beautiful white gold bracelet for the one you love. 199.99 0.75 25 Bracelets Womens White Gold 1 1 EOREOR CC001WG CC001YG.gif Yellow Gold Bracelet This is a beautiful yellow gold bracelet for the one you love. 179.99 0.75 50 Bracelets Womens Yellow Gold 1 1 EOREOR DD002WG DD002WG.gif Big White Gold Bracelet This is another beautiful white gold bracelet for the one you love. 179.99 0.75 5 Bracelets Womens White Gold 1 1 EOREOR I then went to the admin tool, chose Easy Populate from the Catalog submenu, and entered the text file's name in the "insert into db" box and clicked "insert into db". Every time I get the following results (no matter which of the three records/products come first - in the row right after the fieldnames) at the top of the Easy Populate admin page: Easy Populate 2.76d-MS2 - Default Language : English(1) Filename: testdata.txt | BB002WG | BB002WG.gi | Big White | This is an | 179.99 | 0.75 | 5 | Bracelets | Womens | White Gold | | | 1 | 1 !New Product! | CC001WG | DD001WG | if i went into the text file and swapped the order of the products, i'd get: Easy Populate 2.76d-MS2 - Default Language : English(1) Filename: testdata.txt | CC001WG | CC001YG.gi | Yellow Gol | This is a | 179.99 | 0.75 | 50 | Bracelets | Womens | Yellow Gol | | | 1 | 1 !New Product! | DD002WG | BB001WG | so finally, trying to follow some advice from one of the Easy Populate addenda that i found in the contributions section, i downloaded the products in the database (setup by default), deleted all but the column names, and put in two full records using data for every field, whether i needed it or not (german fields, spanish fields, etc). the input file: v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_products_name_2 v_products_description_2 v_products_url_2 v_products_name_3 v_products_description_3 v_products_url_3 v_products_price v_products_weight v_date_avail v_date_added v_products_quantity v_manufacturers_name v_categories_name_1 v_categories_name_2 v_categories_name_3 v_categories_name_4 v_categories_name_5 v_categories_name_6 v_categories_name_7 v_tax_class_title v_status EOREOR AA1YG AA1YG.gif Simple Yellow Gold Ring This is a simple yellow gold ring. http://www.gohere.com Simple Yellow Gold Ring (German) This is a simple yellow gold ring. (German) http://www.gohere.de Simple Yellow Gold Ring (Spanish) This is a simple yellow gold ring (Spanish) http://www.gohere.sp 199.99 0.75 25 Rings Womens Yellow Gold Taxable Goods Active EOREOR AA1WG AA1WG.gif Simple White Gold Ring This is a simple white gold ring. http://www.gohere.com Simple White Gold Ring (German) This is a simple white gold ring. (German) http://www.gohere.de Simple White Gold Ring (Spanish) This is a simple white gold ring (Spanish) http://www.gohere.sp 199.99 0.75 25 Rings Womens White Gold Taxable Goods Active EOREOR the results: Easy Populate 2.76d-MS2 - Default Language : English(1) Filename: newtestdata.txt | AA1YG | AA1YG.gif | Simple Yel | This is a | http://www | Simple Yel | This is a | http://www | Simple Yel | This is a | http://www | 199.99 | 0.75 | | | 25 | | Rings | Womens | Yellow Gol | | | | | Taxable Go | Active !New Product! | AA1WG AA1 | the question, why is only the first record being inserted into the db as a "!New Product!", then whatever records follow are cut off after what seems to be the first field (actually, it looks like more than the first field - the first 9 or so characters - in the second example)? and why does it do it no matter which of the records i put first? any help would be appreciated. thanx m brian ladner brian (dot) ladner (at) gmail (dot) com
  8. I am using osCommerce 2.2 Milestone 2 Update 060817 on a Mac (Darwin Kernel Version 7.9.0) and keep hitting the following problem: Given the following testdata.txt file (either "uploaded and imported" or "imported from temp directory") I keep getting the results below: # more testdata.txt v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_price v_products_weight v_date_avail v_products_quantity v_manufacturers_name v_categories_name_1 v_ca tegories_name_2 v_categories_name_3 v_categories_name_4 v_categories_name_5 v_categories_name_6 v_categories _name_7 v_date_added v_date_avail v_tax_class_id v_status EOREOR BB001WG BB001WG.gif White Gold Bracelet This is a beautiful white gold bracelet for the one you love. $199.99 0.75 25 Bracelets Womens White Gold EOREOR BB001YG BB001YG.gif Yellow Gold Bracelet This is a beautiful yellow gold bracelet for the one you love. $179.99 0.75 50 Bracelets Womens Yellow Gold EOREOR BB002WG BB002WG.gif White Gold Bracelet This is another beautiful white gold bracelet for the one you love. $179 .99 0.75 50 Bracelets Womens White Gold EOREOR Filename: testdata.txt | BB001WG | BB001WG.gi | White Gold | This is a | $199.99 | 0.75 | | 25 | | Bracelets | Womens | White Gold | | | | | | | | !New Product! | BB001YG | BB002WG | so one product gets entered into the products database, then the first fields are examined on the next two rows then skipped. am i missing something? thanks brian ladner brian.ladner@gmail.com
×