multilanguage feature

[gwen]

of course not...not enough time 
use the configuration describe still reply #39 and it might work
sorry I can't help you more than that

[micky3248]

Hi all,

  I installed the hack of esteve and it seamed to work great. Now I'm just getting an error message when I add a new product (phpshop seams not to find the categories to show after saving product). Here the error:

Code: [Select]

Category: 
Warning: array_keys() [function.array-keys]: The first argument should be an array in E:\Mes Documents\Travail\Strokes\Website\xampplite\htdocs\mamboshop\components\com_mambelfish\classes\mambelfish.class.php on line 164
On the frontend, I also get an error:

Code: [Select]

Browse

Warning: Division by zero in E:\Mes Documents\Travail\Strokes\Website\xampplite\htdocs\mamboshop\administrator\components\com_phpshop\html\shop.browse.php on line 661
I'm posting here because I think it could come from mambelfish or the hack. I used the one of the posting #39.

The last thing is that I cannot configure my phpshop in the backend. Each time I click there on the component, it jumps to the frontend. Is it normal? In my first installation, it wasn't doing this.

  Thx in advance for any help. Micky

[dexcaesar]

Hello,

Thanks a lot for the job on this hack ^^

But there is still a probleme I can't solve : I have install files from post #39, everything works fine exept the category translations (I'd already translated in the BackEnd and publish).

When I go to "phpShop Product Category"  (in "Content element configuration") in the exemple page, I have an error :

Warning: Invalid argument supplied for foreach() in /home/robe/public_html/mag/administrator/components/com_mambelfish/admin.mambelfish.html.php on line 467

Thanks in advance for any help.

Dex

[gorgorito]

Hi there evebody,

I have followed the instructions and uploaded the files from #reply 39, everything seems to work find except for when I try to translate the phpShop product category. It gives me this error:

Unknown column \'3c88675a1fefbc02e445a9fee4874d3a\' in \'where clause\' SQL=select * \n from mos_mbf_content\n where reference_id=3c88675a1fefbc02e445a9fee4874d3a\n and reference_table=\'pshop_category\'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 \'e6ffc7d83708702e10589eeb84\n and reference_table=\'pshop_catego SQL=select * \n from mos_mbf_content\n where reference_id=6506e8e6ffc7d83708702e10589eeb84\n and reference_table=\'pshop_category\'Unknown column \'602eda0e00fda7d0a99fb8b62060a270\' in \'where clause\' SQL=select * \n from mos_mbf_content\n where reference_id=602eda0e00fda7d0a99fb8b62060a270\n and reference_table=\'pshop_category\'Unknown column \'1201d9610b05c9ef1cebeb8d33ff7baf\' in \'where clause\' SQL=select * \n from mos_mbf_content\n where reference_id=1201d9610b05c9ef1cebeb8d33ff7baf\n and reference_table=\'pshop_category\'Unknown column \'d0e0a136de327361f9ce34e009dad6f5\' in \'where clause\' SQL=select * \n from mos_mbf_content\n where reference_id=d0e0a136de327361f9ce34e009dad6f5\n and reference_table=\'pshop_category\'Unknown column \'76412da7393335aaee3e8945a6b30510\' in \'where clause\' SQL=select * \n from mos_mbf_content\n where reference_id=76412da7393335aaee3e8945a6b30510\n and reference_table=\'pshop_category\'Unknown column \'3477310027b004a72ab810faa3261eae\' in \'where clause\' SQL=select * \n from mos_mbf_content\n where reference_id=3477310027b004a72ab810faa3261eae\n and reference_table=\'pshop_category\'Unknown column \'868d5f4ad4393913a20365c0bac91f03\' in \'where clause\' SQL=select * \n from mos_mbf_content\n where reference_id=868d5f4ad4393913a20365c0bac91f03\n and reference_table=\'pshop_category\'Unknown column \'a09d1f78be20c79381a2cc990e7dccda\' in \'where clause\' SQL=select * \n from mos_mbf_content\n where reference_id=a09d1f78be20c79381a2cc990e7dccda\n and reference_table=\'pshop_category\

Please help, how do I fix this???

Thanks a lot

[Thorsten Engel]

great job esteve... everything seems to be working fine.
But is it possible to translate the Shop Information??
Any ideas about that?
Or did I miss something?

Thx, Angel

[esteve]

Hi conanqtran,

if you cannot see option to translate:
select for example "phpshop product category" from mambelfish's  drop down list. (on mbf tranlation page)
If you see nothing, (no categories), then check your table 'mos_pshop_category': is category_id int or varchar?

If it is varchar, then (sorry to say) you have to convert it. Soeren made a little script for it. (It is available in this topic, earlier.)

Steve

[esteve]

in the next step where the payment method is only displayed it ist the original language and not translated

Hi Roxxinger,

you have right.
Fix: ps_checkout.php in function final_info() (line 2008)

Code: [Select]

//instead of this
//      $database->setQuery("SELECT payment_method_name FROM #...
      $database->setQuery("SELECT payment_method_id, payment_method_name FROM #...

Steve

[esteve]

Unknown column \'3c88675a1fefbc02e445a9fee4874d3a\' in

Hi gorgorito,

I have a good news: you might have to run a little script (made by Soeren, published in this topic: Reply #7 on: April 29, 2005).
Its reason (extraction from sql directory of phpshop):

Code: [Select]

# The Field Types for all occurences of category_id have been changed from VARCHAR to INT.

Steve

[esteve]

...getting an error message when I add a new product
....phpshop seams not to find the categories to show after saving product

Hi Micky,
it's new for me, and cannot repro.
It seems to be the same problem as gorgorito has.
I suggest you to check type of category_id column in your database. I hope it is varchar, and this solves the error.
If it is ok, please show a line from your category and category_xref tables.

Steve

[esteve]

But is it possible to translate the Shop Information??

Hi Angel,

attached file contains an xml for translating shop information.
Update components/com_mambelfish/classes/mambelfish.class.php, and shop.tos.php (this shows terms of service).

Steve

[Thorsten Engel]

Steve, you didn't code it just for me, did you?!? o_O
Thanx very much for that.
I have a problem right now get it to work.
Everything from post #39 works. But I don't get the shop-infos translated.
But I think it's my fault somehow.

Thank you for your work.
If you consider marriage one time, please let me know ;-)

Angel

EDIT: Sorry... it was really my fault. i forgot to install one of the files...

[Roxxinger]

in the next step where the payment method is only displayed it ist the original language and not translated

Hi Roxxinger,

you have right.
Fix: ps_checkout.php in function final_info() (line 2008)

Code: [Select]

//instead of this
//      $database->setQuery("SELECT payment_method_name FROM #...
      $database->setQuery("SELECT payment_method_id, payment_method_name FROM #...

Steve

hi steve

thx alot works fine now...great job

[dexcaesar]

Hello everybody

I search a lot for a solution to my problem but I can't find any.  :/

Did someone had and solved the same problem ? And can he give me the way ?

Thanks A LOT in advance for any help.

Here is the warning :

Hello,

Thanks a lot for the job on this hack ^^

But there is still a probleme I can't solve : I have install files from post #39, everything works fine exept the category translations (I'd already translated in the BackEnd and publish).

When I go to "phpShop Product Category"  (in "Content element configuration") in the exemple page, I have an error :

Warning: Invalid argument supplied for foreach() in /home/robe/public_html/mag/administrator/components/com_mambelfish/admin.mambelfish.html.php on line 467

Thanks in advance for any help.

Dex

[esteve]

Hi Dex,

I'm sorry, but when I read your email 3rd, then I realize that the error occurs on "MambelFish/Content Element Configuration/Sample data"!
To tell you the truth I've never been there.

The fix:
admin.mambelfish.html.php line 451

Code: [Select]

$sqlFields = "";
$id_colum_name = "id"; //mod
foreach( $contentTable->Fields as $tableField ) {
if ($tableField->Type == 'referenceid') //mod
    $id_colum_name = $tableField->Name; //mod

and line 467

Code: [Select]

. "\nORDER BY $id_colum_name limit 0,10";

Good luck,
Steve

[Roxxinger]

hi me again

did anybody translated the product custom attribute?
i hope i get it to work but would appreciate some hints

jan