Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Cool Flash Carousel Menu


Guest

Recommended Posts

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!!!

Link to comment
Share on other sites

  • Replies 641
  • Created
  • Last Reply

Top Posters In This Topic

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.

Always back up before making changes.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

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?..

Link to comment
Share on other sites

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/

Link to comment
Share on other sites

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

Always back up before making changes.

Link to comment
Share on other sites

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 by zeppos
Link to comment
Share on other sites

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

Link to comment
Share on other sites

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?

Always back up before making changes.

Link to comment
Share on other sites

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 by DanielaQ
Link to comment
Share on other sites

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;

}

}

?>

Link to comment
Share on other sites

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;

}

}

?>

Link to comment
Share on other sites

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 by jan64

Dreams can come true, if you help them a littlebit

Link to comment
Share on other sites

  • 2 weeks later...
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

Link to comment
Share on other sites

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 :)

Link to comment
Share on other sites

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 by jlynskey
Link to comment
Share on other sites

  • 4 weeks later...
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

Link to comment
Share on other sites

  • 2 weeks later...
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 ?

 

83238658.th.png

Link to comment
Share on other sites

  • 3 weeks later...
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 ?

 

83238658.th.png

 

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 by ComArge
Link to comment
Share on other sites

  • 2 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...