DanielaQ Posted June 30, 2009 Share Posted June 30, 2009 Hi friends.. I downloaded and instaled the last version, but when i want toi acces to my shop, i get these message: 1146 - Table 'sg000258_shop.TABLE_FLASH_CAROUSEL' doesn't exist select flash_carousel_id from TABLE_FLASH_CAROUSEL where status = '1' and now() >= expires_date and expires_date > 0 [TEP STOP] Some help?? Thanks!!! Quote Link to comment Share on other sites More sharing options...
♥ecartz Posted June 30, 2009 Share Posted June 30, 2009 1146 - Table 'sg000258_shop.TABLE_FLASH_CAROUSEL' doesn't exist select flash_carousel_id from TABLE_FLASH_CAROUSEL where status = '1' and now() >= expires_date and expires_date > 0 You are missing a line from includes/database_tables.php -- something like define('TABLE_FLASH_CAROUSEL', 'flash_carousel'); I'm not sure about the flash_carousel. It would be whatever the name of the table that you added to the database is. I would advise reading through the contribution again and see if you might have missed a step. If that doesn't work, you'll have to try to find the name of the table in the SQL that it has you run. Quote Always back up before making changes. Link to comment Share on other sites More sharing options...
DanielaQ Posted June 30, 2009 Share Posted June 30, 2009 I checked all twice.. maybe the error is something with the database.. but i dont get an idea.. i still seraching, thankss! You are missing a line from includes/database_tables.php -- something like define('TABLE_FLASH_CAROUSEL', 'flash_carousel'); I'm not sure about the flash_carousel. It would be whatever the name of the table that you added to the database is. I would advise reading through the contribution again and see if you might have missed a step. If that doesn't work, you'll have to try to find the name of the table in the SQL that it has you run. Quote Link to comment Share on other sites More sharing options...
DanielaQ Posted June 30, 2009 Share Posted June 30, 2009 I find the answer, and solve it. But the Flash modelue appears in the admin, but no in the catalog.. I still searching... I checked all twice.. maybe the error is something with the database.. but i dont get an idea..i still seraching, thankss! Quote Link to comment Share on other sites More sharing options...
p_eter Posted July 4, 2009 Share Posted July 4, 2009 hello, I'd like to thank the author for this great contribution and I'd also like your help about a couple of things. I installed the latest version of Flash Carousel and it worked perfectly fine out of the box. However I have 2 problems. Some products are in a different language than english (ie. greek, using utf-8 in the DB and everywhere else) and their name doesnt show on the flash carousel. Furthermore instead of the euro sign, I only see a "€" thing. Can you help me with this please? The site being tested is http://www.t-store.gr, you can see a pen on the flash carousel and this has a name in greek that doesnt show at all. Hello! style-1 filter caracters special (.fla). Test with style-2?.. Quote Link to comment Share on other sites More sharing options...
DanielaQ Posted July 7, 2009 Share Posted July 7, 2009 Hi friends, i reinstalled the OSCOMMERCE_FLASH_CAROUSEL_3.2_1 with no problems. In the admin the carousel appears and I can see the carousel module, no problem in that part. But when i open my site in one part these error: Fatal error: Call to undefined function flash_carousel_product_name() in /home/sg000258/public_html/tienda/catalog/includes/modules/flash_carousel.php on line 97 One thing i remember of my customized store is in the part where is the error i have the FEATURED PRODUCTS insted of NEW_PRODUCTS so, in the 13 step of the installating, in the catalog/admin i added the sentence before FEATURED (intead new_products). Anyone can help me? My store is working and i want to fix it! If someone would like to check: http://www.skateargentino.com.ar/tienda/catalog/ Quote Link to comment Share on other sites More sharing options...
♥ecartz Posted July 7, 2009 Share Posted July 7, 2009 Fatal error: Call to undefined function flash_carousel_product_name() in /home/sg000258/public_html/tienda/catalog/includes/modules/flash_carousel.php on line 97 One thing i remember of my customized store is in the part where is the error i have the FEATURED PRODUCTS insted of NEW_PRODUCTS so, in the 13 step of the installating, in the catalog/admin i added the sentence before FEATURED (intead new_products). I don't think that would matter (you did the right thing there). The error it is giving you suggests that you missed step 11, where you were supposed to end up with code like tep_expire_specials(); // auto expire flash carousel products require(DIR_WS_FUNCTIONS . 'flash_carousel.php'); tep_expire_flash_carousel(); in includes/application_top.php Quote Always back up before making changes. Link to comment Share on other sites More sharing options...
zeppos Posted July 7, 2009 Share Posted July 7, 2009 (edited) Hello! style-1 filter caracters special (.fla). Test with style-2?.. thanks for the consideration. i have solved the problem a long time ago, with the exemplary support and advice of the CFC developer. if I remember correctly the original .fla sources were using latin-1 instead of utf-8 encoding. so it was only a matter of making this little change in the .fla file and rewrapping it to swf. now it works perfectly well as you can see in www.t-store.gr as for the euro sign problem, i think i changed something in the functions/flash_carousel.php file, $patterns[0]=’/#8364/’; (plus the &, i removed it coz this thing autoparses it to the euro sign!) changed to ---> $patterns = ‘/€/’; the details can be seen somewhere here: http://www.oscommercex.com/2009/04/oscomme...eased/#more-286 there's one small problem remaining with the max limit of the product text shown in CFC. the max size works perfectly well for the english fonts but not for the greek fonts, however this is something i will try to solve in the future Edited July 7, 2009 by zeppos Quote Link to comment Share on other sites More sharing options...
DanielaQ Posted July 7, 2009 Share Posted July 7, 2009 Hi! No, I'm sure i'm not missed anystep (now i used to wrtite in a paper all the files i modified. i checked the application_top.. and its ok: // auto expire special products require(DIR_WS_FUNCTIONS . 'specials.php'); tep_expire_specials(); // auto expire flash carousel products require(DIR_WS_FUNCTIONS . 'flash_carousel.php'); tep_expire_flash_carousel(); // auto expire featured products require(DIR_WS_FUNCTIONS . 'featured.php'); tep_expire_featured(); Any other idea?? Thanks for replying!! I don't think that would matter (you did the right thing there). The error it is giving you suggests that you missed step 11, where you were supposed to end up with code like tep_expire_specials(); // auto expire flash carousel products require(DIR_WS_FUNCTIONS . 'flash_carousel.php'); tep_expire_flash_carousel(); in includes/application_top.php Quote Link to comment Share on other sites More sharing options...
♥ecartz Posted July 7, 2009 Share Posted July 7, 2009 Any other idea?? Thanks for replying!!Have you verified that the function flash_carousel_product_name() exists in includes/functions/flash_carousel.php? It looks like it is a newer function. Maybe you have an older version of the file? Quote Always back up before making changes. Link to comment Share on other sites More sharing options...
DanielaQ Posted July 7, 2009 Share Posted July 7, 2009 (edited) Hi! I downloaded the 3.2_1 few days ago, so i have to supose its the last version. I checked the flash_carousel and search the function, i founded: // Added version 3.2 06.04.2009 function flash_carousel_product_name($product_name){ $product_name = strip_tags($product_name); $patterns[0] = '/€/'; $replacements[0] = '€'; $product_name = preg_replace($patterns, $replacements, $product_name); $product_name = xmlspecialchars($product_name); return $product_name; } // Added version 3.2 06.04.2009 I u like I can copy all the file , Thanks! Have you verified that the function flash_carousel_product_name() exists in includes/functions/flash_carousel.php? It looks like it is a newer function. Maybe you have an older version of the file? Edited July 7, 2009 by DanielaQ Quote Link to comment Share on other sites More sharing options...
DanielaQ Posted July 7, 2009 Share Posted July 7, 2009 Have you verified that the function flash_carousel_product_name() exists in includes/functions/flash_carousel.php? It looks like it is a newer function. Maybe you have an older version of the file? This is my includes/functions/flah_carousel.php: <?php /* osCommerceX, osCommerce Lab http://www.oscommercex.com Version 3.2 05.04.2009 Copyright © 2009 osCommercex Released under the GNU General Public License */ //// // Sets the status of a flash_carousel product function tep_set_flash_carousel_status($flash_carousel_id, $status) { return tep_db_query("update " . TABLE_FLASH_CAROUSEL . " set status = '" . $status . "', date_status_change = now() where flash_carousel_id = '" . $flash_carousel_id . "'"); } //// // Auto expire flash_carousel products function tep_expire_flash_carousel() { $flash_carousel_query = tep_db_query("select flash_carousel_id from " . TABLE_FLASH_CAROUSEL . " where status = '1' and now() >= expires_date and expires_date > 0"); if (tep_db_num_rows($flash_carousel_query)) { while ($flash_carousel = tep_db_fetch_array($flash_carousel_query)) { tep_set_flash_carousel_status($flash_carousel['flash_carousel_id'], '0'); } } } //// // Save xml file function savefile($xmldata, $filename){ $directory = FLASH_CAROUSEL_DIRECTORY; if(isset($directory)){ $directory = FLASH_CAROUSEL_DIRECTORY .'/';; } $filename_dir = DIR_FS_CATALOG . $directory . $filename; if ($fp = fopen($filename_dir, 'w+')){ fwrite($fp, $xmldata); fclose($fp); return true; } else return false; } //// // (turkce) xml dosyasini olustur // (english) build xml file function build_xml($data){ $xmlfile='<?xml version="1.0" encoding="'.CHARSET.'"?>'."\n"; $xmlfile.="<products>\n"; $xmlfile.= $data; $xmlfile.="</products>\n"; savefile($xmlfile, 'kampanya.xml'); } function flash_carousel_file($opt='1'){ $flash_carousel_info = explode('::', FLASH_CAROUSEL_STYLE); if($opt=='1') $flash_directory = FLASH_CAROUSEL_DIRECTORY.'/'.$flash_carousel_info['0'].'/'.$flash_carousel_info['1'].'/kampanya.swf'; elseif ($opt=='2') $flash_directory = FLASH_CAROUSEL_DIRECTORY.'/'.$flash_carousel_info['0'].'/'.$flash_carousel_info['1'].'/kampanya'; elseif ($opt=='3') $flash_directory = $flash_carousel_info['0'].'/'.$flash_carousel_info['1'].'/kampanya'; return $flash_directory; } // Added version 3.2 06.04.2009 function flash_carousel_product_name($product_name){ $product_name = strip_tags($product_name); $patterns[0] = '/€/'; $replacements[0] = '€'; $product_name = preg_replace($patterns, $replacements, $product_name); $product_name = xmlspecialchars($product_name); return $product_name; } // Added version 3.2 06.04.2009 function flash_carousel_price($price){ $patterns[0] = '/€/'; $replacements[0] = '€'; $price = preg_replace($patterns, $replacements, $price); return $price; } // Added version 3.2 06.04.2009 function xmlspecialchars($text) { return str_replace(''', ''', htmlspecialchars($text, ENT_QUOTES)); } // Added version 3.2 06.04.2009 if(!function_exists('str_split')) { function str_split($string,$string_length=1) { if(strlen($string)>$string_length || !$string_length) { do { $c = strlen($string); $parts[] = substr($string,0,$string_length); $string = substr($string,$string_length); } while($string !== false); } else { $parts = array($string); } return $parts; } } ?> Quote Link to comment Share on other sites More sharing options...
DanielaQ Posted July 9, 2009 Share Posted July 9, 2009 No one in the world have the file??? This is my includes/functions/flah_carousel.php: <?php /* osCommerceX, osCommerce Lab http://www.oscommercex.com Version 3.2 05.04.2009 Copyright © 2009 osCommercex Released under the GNU General Public License */ //// // Sets the status of a flash_carousel product function tep_set_flash_carousel_status($flash_carousel_id, $status) { return tep_db_query("update " . TABLE_FLASH_CAROUSEL . " set status = '" . $status . "', date_status_change = now() where flash_carousel_id = '" . $flash_carousel_id . "'"); } //// // Auto expire flash_carousel products function tep_expire_flash_carousel() { $flash_carousel_query = tep_db_query("select flash_carousel_id from " . TABLE_FLASH_CAROUSEL . " where status = '1' and now() >= expires_date and expires_date > 0"); if (tep_db_num_rows($flash_carousel_query)) { while ($flash_carousel = tep_db_fetch_array($flash_carousel_query)) { tep_set_flash_carousel_status($flash_carousel['flash_carousel_id'], '0'); } } } //// // Save xml file function savefile($xmldata, $filename){ $directory = FLASH_CAROUSEL_DIRECTORY; if(isset($directory)){ $directory = FLASH_CAROUSEL_DIRECTORY .'/';; } $filename_dir = DIR_FS_CATALOG . $directory . $filename; if ($fp = fopen($filename_dir, 'w+')){ fwrite($fp, $xmldata); fclose($fp); return true; } else return false; } //// // (turkce) xml dosyasini olustur // (english) build xml file function build_xml($data){ $xmlfile='<?xml version="1.0" encoding="'.CHARSET.'"?>'."\n"; $xmlfile.="<products>\n"; $xmlfile.= $data; $xmlfile.="</products>\n"; savefile($xmlfile, 'kampanya.xml'); } function flash_carousel_file($opt='1'){ $flash_carousel_info = explode('::', FLASH_CAROUSEL_STYLE); if($opt=='1') $flash_directory = FLASH_CAROUSEL_DIRECTORY.'/'.$flash_carousel_info['0'].'/'.$flash_carousel_info['1'].'/kampanya.swf'; elseif ($opt=='2') $flash_directory = FLASH_CAROUSEL_DIRECTORY.'/'.$flash_carousel_info['0'].'/'.$flash_carousel_info['1'].'/kampanya'; elseif ($opt=='3') $flash_directory = $flash_carousel_info['0'].'/'.$flash_carousel_info['1'].'/kampanya'; return $flash_directory; } // Added version 3.2 06.04.2009 function flash_carousel_product_name($product_name){ $product_name = strip_tags($product_name); $patterns[0] = '/€/'; $replacements[0] = '€'; $product_name = preg_replace($patterns, $replacements, $product_name); $product_name = xmlspecialchars($product_name); return $product_name; } // Added version 3.2 06.04.2009 function flash_carousel_price($price){ $patterns[0] = '/€/'; $replacements[0] = '€'; $price = preg_replace($patterns, $replacements, $price); return $price; } // Added version 3.2 06.04.2009 function xmlspecialchars($text) { return str_replace(''', ''', htmlspecialchars($text, ENT_QUOTES)); } // Added version 3.2 06.04.2009 if(!function_exists('str_split')) { function str_split($string,$string_length=1) { if(strlen($string)>$string_length || !$string_length) { do { $c = strlen($string); $parts[] = substr($string,0,$string_length); $string = substr($string,$string_length); } while($string !== false); } else { $parts = array($string); } return $parts; } } ?> Quote Link to comment Share on other sites More sharing options...
garnet Posted July 10, 2009 Share Posted July 10, 2009 Hi all, when I resized the flash area form 200 to 150 in height the text describing the items became very unlegible/small. Where do I change the text size. I am using version 2.0d Thanks. Quote OSC beginner Link to comment Share on other sites More sharing options...
jan64 Posted July 12, 2009 Share Posted July 12, 2009 (edited) I have a strange problem. The flash carousel works perfect, for weeks, but i can't change the style anymore. The other configuration settings are no problem. Only when i click on the style, the edit button and the whole tabel on the right is gone. Who knows this problem and how can i solve it? Thanks regards, Jan Edited July 12, 2009 by jan64 Quote Dreams can come true, if you help them a littlebit Link to comment Share on other sites More sharing options...
jlynskey Posted July 23, 2009 Share Posted July 23, 2009 Hey,when I install this contrib a pop up gambling ad now appears from my site! Only in IE though... I didn't even know as I use FF... :blink: you probably got that some other way. the best way to get rid on that is to add the gambling site url to your hosts file. that will block any pop up ads from that site. for info about hosts file: http://www.mvps.org/winhelp2002/hosts.htm Quote Link to comment Share on other sites More sharing options...
jlynskey Posted July 23, 2009 Share Posted July 23, 2009 first i would like to say thank you for such a great contribution. i am excited top see it working. unfortunately, i was a bit disappointed to see that it didnt work perfectly with my site though. still, its probably one of my favorite contributions. i am currently running osc version rc2a with STS on localhost. i was hoping someone might be able to help me with a couple of issues. the first problem is that i am using a combination of nested tables and css for my layout and the flash carousel seems to mess up the css positioning of elements on my page. also, the width of the flash box seems to be larger than the width of the content page table cell. the flash box also has two white spaces on either side of it. so far i can change the size of the flash box, but it doesnt get rid of the white spaces or fix the messed up css positioning issue. i would like to get rid of the white spaces and keep the same size of the rotating carousel so that it would fit within the table cell. Put it in a div, absolute position & overlay i think this solution will fix issues with putting the carousel within a fixed width store but im not sure exactly how to do this. anyone mind telling me how to put the carousel into a div, absolute position and overlay? the next problem that i am having is with STS. i have looked over a few hundred previous posts on this so as i understand, the flash carousel works fine with STS. as i have read in a previous post, someone had an STS issue that was solved somehow with the .js file. i am not sure if i have the same issue or if my problem can be solved in the same way but here is the error messages that i am getting: message from top of browser: Notice: Undefined variable: formfirst in C:\xampp\htdocs\catalog\includes\functions\sts.php on line 64 message brom bottom of browser: Notice: Undefined property: sts::$display_debug_output in C:\xampp\htdocs\catalog\includes\modules\sts_inc\sts_display_output.php on line 33 i would be grateful if anyone could help. thank you :) Quote Link to comment Share on other sites More sharing options...
jlynskey Posted July 23, 2009 Share Posted July 23, 2009 (edited) ok so one probem is solved so far.... i was reading over the support website by the contributor of this mod (http://www.oscommercex.com) and i learned that by putting "//" infront of "error_reporting(E_ALL);" in file "catalog/includes/classes/flash_carousel_image_resize.php", you get rid of the error messages. so far that got rid of the error (notice) messages and fixed the css element layout displacement. :D however, i still need to get rid of the white spaces to the side of the rotating carousel and create an overlay for the pop up box that displays the product info. i will dig around and post the solution if i find it. ;) Edited July 23, 2009 by jlynskey Quote Link to comment Share on other sites More sharing options...
willToDo Posted August 20, 2009 Share Posted August 20, 2009 I checked all twice.. maybe the error is something with the database.. but i dont get an idea..i still seraching, thankss! Hi Please could you let me know how you managed to sort out this error Quote Link to comment Share on other sites More sharing options...
willToDo Posted August 20, 2009 Share Posted August 20, 2009 Hi there, I install this mod and now I am getting the following error when I try to get to the main page Any help please. I carried out the mindsparx admin mod prior to this and no problems. osCommerce version 2.2 RC2 Hi Please could you let me know how you managed to solve the above problem I am experiencing something simillar in my site Quote Link to comment Share on other sites More sharing options...
dilana87 Posted August 30, 2009 Share Posted August 30, 2009 I managed to solve my problem, i changed error_reporting in flash_carousel.php to error_reporting(0). Thanks :) Same problem, but i changed error_reporting(E_ALL); to error_reporting(0) in includes\classes\flash_carousel_image_resize.php And i`ve got another problem... At the top of the carousel i`ve got one number and i dont know how to remove it :D And the other problem is with cirylic fonts... Somebody can help me ? Quote Link to comment Share on other sites More sharing options...
dilana87 Posted August 30, 2009 Share Posted August 30, 2009 And i`ve got problem... At the top of the carousel i`ve got one number and i dont know how to remove it :D And the other problem is with cirylic fonts... Somebody can help me ? Quote Link to comment Share on other sites More sharing options...
Guest Posted September 21, 2009 Share Posted September 21, 2009 (edited) And i`ve got problem... At the top of the carousel i`ve got one number and i dont know how to remove it :DAnd the other problem is with cirylic fonts... Somebody can help me ? Open catalog/includes/classes/flash_carousel_image_resize.php file and find below line; $this->error = 1; And replace with below line; //$this->error = 1; Edited September 21, 2009 by ComArge Quote Link to comment Share on other sites More sharing options...
yaoi Posted October 1, 2009 Share Posted October 1, 2009 hello nice contribution but how do you install style 3 as found on the flash carousel website? thanks Quote Link to comment Share on other sites More sharing options...
Wolmaister Posted October 1, 2009 Share Posted October 1, 2009 after i added the flash_carousel_english.sql succesfully and wanted to test my site after i added the new files and modified files this happened Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.