Product Extra Fields for text, pdfs and flash

[marknew]

Looks like a great mod, Thanks.
I'm having trouble with the pdf upload. When i preview a new product I get "Error: Destination does not exist /home/newmedia/public_html/newmediastudio/onlinequote/download/products_extra_files"

My site is in a subdirectory of my site - http://newmediastudio.com.au/onlinequote so this looks right to me. I have created the download/products_extra_files folder at the root level as well and set all4 folder permissions to 777.
I also tried changing define('DIR_FS_PRODUCT_EXTRA', 'product_extra_files/');
to
define('DIR_FS_PRODUCT_EXTRA', 'onlinequote/product_extra_files/');

in product_database_names.php but still get the same error. I guess it's something to do with being in a subdirectory?

[marknew]

Just found another problem Iam have. I think it's related to Easy Populate. When I try to add a new product I get this error -

1146 Table 'newmedia_zc8.TABLE_PRODUCT_EXTRA_DESCRIPTION_EXTRA' doesn't exist
in:
[insert into TABLE_PRODUCT_EXTRA_DESCRIPTION_EXTRA (products_id, products_code, file_1, file_2, file_3, file_4, file_1_title, file_2_title, file_3_title, file_4_title) values ('1', null, '/tmp/php1F2Kbl', null, null, null, 'CSS Cheat', null, null, null)]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.


I saw some other posts about using this with Easy populate. can they be used together?

Thanks.

[delia]

You haven't run the sql file or else you have a prefix on your database tables. This has nothing to do with EZ populate.

That error message is putting the onlinequote into a folder called newmediastudio so it's a sub directory of a subdirectory. That sounds like an incorrect or unusable setting in your admin configure file. Are you able to click on the online catalog link on admin and get to your cart?

[marknew]

Thanks,

the zencart was installed with fantastico so it has zen_ prefix. How do i fix that?

Yes, the admin link takes me to the catalogue. Here's my config file.

define('HTTP_SERVER', 'http://newmediastudio.com.au');
define('HTTPS_SERVER', 'https://newmediastudio.com.au');

// Use secure webserver for checkout procedure?
define('ENABLE_SSL', 'false');

// NOTE: be sure to leave the trailing '/' at the end of these lines if you make changes!
// * DIR_WS_* = Webserver directories (virtual/URL)
// these paths are relative to top of your webspace ... (ie: under the public_html or httpdocs folder)
define('DIR_WS_CATALOG', '/onlinequote/');
define('DIR_WS_HTTPS_CATALOG', '/onlinequote/');

define('DIR_WS_IMAGES', 'images/');
define('DIR_WS_INCLUDES', 'includes/');
define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');
define('DIR_WS_DOWNLOAD_PUBLIC', DIR_WS_CATALOG . 'pub/');
define('DIR_WS_TEMPLATES', DIR_WS_INCLUDES . 'templates/');

define('DIR_WS_PHPBB', '/');

// * DIR_FS_* = Filesystem directories (local/physical)
//the following path is a COMPLETE path to your Zen Cart files. eg: /var/www/vhost/accountname/public_html/store/
define('DIR_FS_CATALOG', '/home/newmedia/public_html/newmediastudio/onlinequote/');

define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');
define('DIR_WS_UPLOADS', DIR_WS_IMAGES . 'uploads/');
define('DIR_FS_UPLOADS', DIR_FS_CATALOG . DIR_WS_UPLOADS);
define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/');

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', 'zen_');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'XXXXXX');
define('DB_SERVER_PASSWORD', 'XXXXXX');
define('DB_DATABASE', 'XXXXXXXX');
define('USE_PCONNECT', 'false');
define('STORE_SESSIONS', 'db');
// for STORE_SESSIONS, use 'db' for best support, or '' for file-based storage

// The next 2 "defines" are for SQL cache support.
// For SQL_CACHE_METHOD, you can select from: none, database, or file
// If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache
// or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder
// ie: /path/to/your/webspace/public_html/zen/cache -- leave no trailing slash
define('SQL_CACHE_METHOD', 'none');
define('DIR_FS_SQL_CACHE', '/home/newmedia/public_html/newmediastudio/onlinequote/cache');

[delia]

you would need to change the table name in your database. Do you know how to do that? Do you have access to your database to do that?

[kobra8]

I'm sorry but I do not understand the purpose of this module, if anyone can explain me for what purpose can be used?

[delia]

Adds extra fields to a products and provides automatic display of pdfs for download or display of flash or display of extra text. Each field can be individually displayed and formatted if one wants to reformat the product info template.

[kobra8]

Thanks delia on responce,

when I install add ons can I determine which products to have Extra Fields for text, pdfs and flash or all products have Extra Fields?

Because it would be great to only certain products may assign this function.

[delia]

The extra fields only show up if they have something in them.

[pizza392]

in the "extra field", i can only input one language, what do i make it used for multi languages just like the description area?