yhlai 2007-2-25 16:01
mambo + phpshop + paypal + forum 问题
mambo + phpshop + paypal + forum 问题
各位, 我在安装mambo出现这些问题 (对不起我做了很多的测试..):
希望各位可以帮帮我给我意见, 先谢 :p
其实用那一个forum也没有问题, 只要没error就可以了.
我使用的server是行php5和mysql5.
首先我用最新版的mambo(4.5.5) + phpshop(1.2 stable pl3)/virtuemart(1.0.9) 安装,
phpshop 和 vitruemart不约而同都出了这个error:
错误: 模块尚未注册。"store" 不是有效的 VirtueMart 模块.
而且phpshop里面的 admin-> users 更加出现error:
DB function failed with error number 1054
Unknown column 'aro.id' in 'on clause' SQL=SELECT a.*, g.name AS groupname FROM mos_users AS a INNER JOIN mos_core_acl_aro AS aro ON aro.value = a.id INNER JOIN mos_core_acl_groups_aro_map AS gm ON gm.aro_id = aro.id INNER JOIN mos_core_acl_aro_groups AS g ON g.id = gm.group_id LIMIT 0, 10
之后我search了一个已嵌入的mambo + phpshop:
[url]http://sourceforge.net/projects/mambo-phpshop/[/url]
然后自行做了点debug(部份在网上找来改的):
- installation/sql/mambo.sql
line 223:
`rating_sum` int(11) unsigned NOT NULL default '',
改做:
`rating_sum` int(11) unsigned NOT NULL default '0',
line 1115:
`order_total` DECIMAL( 10, 2 ) DEFAULT '0,0' NOT NULL,
改做:
`order_total` DECIMAL( 10, 2 ) DEFAULT '0' NOT NULL,
- installation/sql/sample_data.sql (清空里面所有data)
解决mysql5的问题:
[url]http://forum.mamboserver.com/showthread.php?t=65497[/url]
[url]http://forum.mamboserver.com/archive/index.php/t-73761.html[/url]
- administrator/components/com_content/admin.content.php
line 201
old: . "\n FROM , #__content AS c, #__categories AS cc, #__sections AS s"
new: . "\n FROM #__categories AS cc, #__sections AS s, #__content AS c "
Line 312
old: . "\n FROM , #__content AS c, #__categories AS cc, #__sections AS s"
new: . "\n FROM #__categories AS cc, #__sections AS s, #__content AS c "
在安装好这个mambo+phpshop之后:
Chmod 666 on /public_html/administrator/components/com_phpshop/classes/payment/*cfg.php
加进alipay(参考):
[url]http://bbs.mambochina.net/viewthread.php?tid=10286&extra=page%3D6[/url]
[url]http://bbs.mambochina.net/viewthread.php?tid=10334&extra=page%3D1&page=1[/url]
基本上到这里大问题已经解决(但未解决是否正确pass到data到alipay和paypal, 希望这里各位可以给我一点意见)
之后的都是未成功的问题:
case 1, 使用phpbb component:
[url]http://mamboxchange.com/projects/phpbb/[/url]
非常容易安装, 而且能够把登入由mambo带到phpbb.
问题:
1. phpbb好像把phpshop给block了(最大的问题).
2. 不能disable mambo 4.5.2本来的登入module
3. 登入和登出要使用mambo原本那个, 但注册要使用phpbb component那个
case 2, 使用SMF 1.0.5 + MOS_SMF_BRIDGEv3.19a_stable:
ref:
[url]http://forum.mamboserver.com/showthread.php?t=58262[/url]
[url]http://forum.mamboserver.com/showthread.php?t=58262&page=2&pp=16[/url]
download:
[url]http://www.simplemachines.org/download/index.php?thanks;filename=smf_1-0-5_install.zip[/url]
[url]http://mamboforge.net/frs/download.php/6472/MOS_SMF_BRIDGEv3.19a_stable.zip[/url]
安装SMF然后更新, SMF会更新到1.0.7, 之后安装smf bridge (安装是没有问题).
问题是forum和mambo需要各自登入.
case 3, 使用SMF 1.1.2/1.1 + MamboSMFForum_1.3.2b1:
download:
[url]http://www.simplemachines.org/download/index.php/smf_1-1_install.tar.gz[/url]
[url]http://mamboxchange.com/projects/mambo-smf/[/url]
Steps:
SMF 1.1 beta3p和Mambo452 connection: [url]http://www.allkwebbor.com/content/view/74/1/[/url]
问题跟case2一样, 而且在安装module时SMF对部份phh (eg: Subs.php)不能够更新.
case 4 (discuz):
ref:
[url]http://bbs.mambochina.net/viewthread.php?tid=8093[/url]
问题:完全失败, module做不了bridge它们的功能.
谢谢解答