Ralf_Tech

@@De Dokta http://www.oscommerce.com/forums/topic/399753-table-edit-instructions-addon-invoice-editor-10-8885/#entry1713860 Dr.J ,I closed my post (above link) and now further on this thread. Got 5 more questions, I hope you can help me on my way, allready thx : 1) The change you suggested works : " drop table if exists invoice_orders; create table invoice_orders LIKE orders; drop table if exists invoice_orders_products; create table invoice_orders_products LIKE orders_products; drop table if exists invoice_orders_products_attributes; create table invoice_orders_products_attributes LIKE orders_products_attributes; drop table if exists invoice_orders_products_download; create table invoice_orders_products_download LIKE orders_products_download; drop table if exists invoice_orders_total; create table invoice_orders_total LIKE orders_total;" So is that enough for the sql's needed to run at my live shop? So I only import the invoice_en.sql file and I don't import new_tables.sql but instead type above suggested sql in phpmyadmin? Thats all? Y or N? 2) Where is the 3th sql file in your addon package used for: invoice.sql? 3) This section from your install.txt : "NOTE: This function uses the column 'orders_date_finished' in the table 'orders', which already exists but normally is not in use. If any of your contribs uses this column, you have to create a new column: ALTER TABLE `orders` ADD `any_name` YEAR(4) NULL default NULL; Additionally you have to replace 'orders_date_finished' with 'any_name' at all sites in the two files "orders_message.php" and "invoice_num.php" !" Should I do someting with this instruction or not? Do you know if 1 of my 3 installed addon's uses this table? 4) I made a new folder in my admin: invoices/ and I set the proper instructions in my shop admin: Save invoices? true Storage Directory testshop/admin/invoices/ But when I want to print my PDF invoice I know get this error message: "Warning: fopen(testshop/admin/invoices/1.pdf) [function.fopen]: failed to open stream: Bestand of map bestaat niet in /home/sportmas/public_html/testshop/admin/fpdf/tfpdf.php on line 1228 FPDF error: Unable to create output file: testshop/admin/invoices/1.pdf" What do you think did I do wrong? 5) My previous installed addon sppc (http://addons.oscommerce.com/info/716) also changes admin/includes/classes/order.php Your addon also changes admin/includes/classes/order.php. But they both change the same text in this file. So what change do I need to make to this original text in order.php , so that both addons are going to work ?: Original text in this file: $order_query = tep_db_query("select customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, currency, currency_value, date_purchased, orders_status, last_modified from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'"); Changes from addon SPPC: // BOF add SPPC customers_group_name to the info $order_query = tep_db_query("select customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, o.customers_telephone, o.customers_email_address, customers_address_format_id, customers_group_name, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, currency, currency_value, date_purchased, orders_status, last_modified from " . TABLE_ORDERS . " o left join " . TABLE_CUSTOMERS . " using(customers_id) left join " . TABLE_CUSTOMERS_GROUPS . " using(customers_group_id) where orders_id = '" . (int)$order_id . "'"); // EOF add SPPC customer_group_name to the info Change in your invoice editor addon: $order_query = tep_db_query("select customers_name, customers_id, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, currency, currency_value, date_purchased, orders_status, num_invoice, pdf_invoice, last_modified from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'");

@@De Dokta Thx. That worked. I have 2 remaining questions left. I will ask them in the thread.

@@De Dokta Hello, I have version 2.3.4. installed on my live webshop (the same set-up in my testshop). I installed on my testshop the following 3 addon's: 1) dutchpack http://addons.oscommerce.com/info/7839 2) sppc http://addons.oscommerce.com/info/716 en 3)subtextcategories http://addons.oscommerce.com/info/7841 Al is working great. Now I want to installed my 4th addon: 8885 (Invoice Editor 1.0 http://addons.oscommerce.com/info/8885 ) I just installed this addon in my testshop. But when I installed the "new Tables.sql" in phpmyadmin I got this error message: Error There seems to be a error in your SQL-query. ERROR: unknown punctuatiestring @ 340 STR: -> SQL: SQL-query: MySQL meldt: #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 '*NOTE: If you have yet added any additional columns to the tables 'orders', 'o' at line 1 When you read the install.txt of this invoice editor 1.0"addon they warn you for this: " NOTE: This function uses the column 'orders_date_finished' in the table 'orders', which already exists but normally is not in use. If any of your contribs uses this column, you have to create a new column: ALTER TABLE `orders` ADD `any_name` YEAR(4) NULL default NULL; Additionally you have to replace 'orders_date_finished' with 'any_name' at all sites in the two files "orders_message.php" and "invoice_num.php" ! IMPORTANT! - IMPORTANT! - IMPORTANT! - IMPORTANT! 3. Update the database using the enclosed invoice_en.sql and new_tables.sql files. NOTE: If you have yet added any additional columns to the tables 'orders', 'orders_products'. 'orders_products_attributes', 'orders_products_download' and 'orders_total', you should NOT run the new_tables.sql. Instead go to your phpmyadmin and create copies of the above tables (only structure / not data) using the prefix invoice_ (e.g. orders -> invoice_orders). If you ignore this warning the invoice editor will NOT work! I allready thought that my previous installed addon sppc http://addons.oscommerce.com/info/716 uses this table. But dont know for sure. But as it is a testshop I first tried to upload the new_tables.sql. QUESTON 1 : Does this 716 indeed uses this table allready? QUESTON 2: So because of the error message in myphpadmin I need to manually change something what the red warning text says in the install.txt. But I really don't know what I should manually change, I dont get this instruction. Can someone explain what I should do instead of importing the new_tables.sql?

@@gadlol @@Gergely @@MrPhil The order e-mails are now correct (didnt do anything much, but when its good its good). But when I use the euro symbol in a file, it's diplayed as a questionmark on the website. The same with special letters like: ä ë ï etc. etc. The euro symbol in my webshop at my product prices is good displayed. I also read this topic. http://forums.oscommerce.com/topic/398874-char-encoding-issue/?hl=%2Beuro+%2Bcurrency I checked the database tabels in my admin and it says in 1 location : extra_cat_info 24 0.02M MyISAM latin1_swedish_ci extra_cat_info is included by the addon: http://addons.oscommerce.com/info/7841 So I guess this could be the problem?? I tried to convert this to UTF-8 with the converter in de shop admin, but still displays latin1_swedisch_ci. When I go to PHPmyAdmin this tabel "extra_cat_info" also shows here the latin1 charset. How can i change this to UTF-8 & is this file the problem of could there be a other problem?

I also checked the dutch and english files in includes/languages. Both these files where also correct : Charset , UTF-8. I changed the e-mail transport emthode to SMTP. Suddenly the euro symbol currency in the order mail was correct. I changed it back to sendmail, and still it was correct. So maybe a glitch?

My english.php and dutch.php in admin/includes/languages both say : // charset for web pages and emails define('CHARSET', 'utf-8'); This should be good, not?

How can you check that ? (strange is that in my testshop, where i also installed all the add-ons, i dont have this problem).

Hi, Working with osCommerce 2.3.4 I stalled the add-ons in following order: 1) Dutch language pack http://addons.oscommerce.com/info/7839 and 2) subcategory textboxes http://addons.oscommerce.com/info/7841 3) SPPC http://addons.oscommerce.com/info/716 4) Extra account create in admin http://addons.oscommerce.com/info/9149 Everything is now working as it should. But 1 minor detail : In the e-mails sended to the customer from the shop the euro currency symbool ( € ) is not reconized, it's beeing displayed as this symbol : Â,¬. Also when i edit a file with text, the euro currency symbool is also displayed with another strage symbol :� I am almost sure this changed after installing above 3th and 4 th add-on. Does anyone knows where i need to change a code (style code?) ?

Thx George. Just compared the original product_info.php with the new product_ino.php with the program beyond compare. And indeed u see fancybox changes on the new file and you see new colorbox changes on the original 2.3.4. file. Now i only modified the SPPC changes in the original file and uploaded that file: Super, images are back as the are supposed to be and SPPC still working. Thanx m8 :thumbsup: :thumbsup: :thumbsup:

Scott, The testshop is now online: www.sportmassageapeldoorn.nl/testshop. Could you check what i mean? Thx "" Everything is working as it should. But there is 1 huge problem with the display of the product images. The product images are, after the installation of this add-on, being, after you mouse-click them, displayed on a new seperate webpage, instead as it should be, and as it was before the add-on, being displayed "in-screen" with a image pop_up. Also, the product with the bigger images are nog displayed as the y should. See what i mean on : http://sportmassagea...&products_id=28 (galaxy tab). So something in the add-on changed the code for diplaying the product images the proper way as it should. Does some one knows what new file in this add-on changed the display and knows in what file i can change this back to how it was and should be without losing the SPPC functions. ""

Hi Scott, I need to reinstall this addon to my testshop, going at it today again. report in this topic when the testshop is online again.

Hello, I am from holland, working with osCommerce version 2.3.4 Buth the Dutch forum is not so active. I just released my live shop and i am now working on adding addons i need. I really need to SPPC addon so my clients see different prices when they log-on. I installed: http://addons.oscommerce.com/info/716 on my testshop : www.sportmassageapeldoorn/testshop Everything is working as it should. But there is 1 huge problem with the display of the product images. The product images are, after the installation of this add-on, being, after you mouse-click them, displayed on a new seperate webpage, instead as it should be, and as it was before the add-on, being displayed "in-screen" with a image pop_up. Also, the product with the bigger images are nog displayed as the y should. See what i mean on : http://sportmassagea...&products_id=28 (galaxy tab). So something in the add-on changed the code for diplaying the product images the proper way as it should. Does some one knows what new file in this add-on changed the display and knows in what file i can change this back to how it was and should be without losing the SPPC functions. Thx. Ralf.