Print Page - PhpMyDirectory and SMF2

Title: PhpMyDirectory and SMF2
Post by: KalkanPrince on July 26, 2009, 08:20:39 AM

Hi,

I have just got PhpMyDirectory (http://www.phpmydirectory.com/features.html) which says it integrates to SMF. I have posted a request for help on their forum but wondered if maybe someone can help here, I am using SMF 2RC1.2 and the latest version of PhpMyDirectory. My smf database is called smf_kalkan and the credentials I entered are correct

The error I receive why trying to login via phpmydirectory is...

A fatal MySQL error occured.

Query:
SELECT memberName, passwd, emailAddress FROM smf_members WHERE memberName='happydays' AND passwd='d8011965b13b524d7f8f97a5d5618a7e37fe4cf3'

Error:
(1054) Unknown column 'memberName' in 'field list'

A fatal MySQL error occured.

Query:
REPLACE INTO pmd_sessions VALUES ('pprsvtj8c6srktoga2c9ik18e1','initiated|b:1;from_pmd|s:32:\"7de81848334c3fee4e09602041d37db1\";',1248622822,'b926f3d41a6b4a2a0754bcad39c22b54')

Error:
(1146) Table 'smf_kalkan.pmd_sessions' doesn't exist

Title: Re: PhpMyDirectory and SMF2
Post by: Dragooon on July 26, 2009, 08:29:39 AM

It seems they are running SMF 1.x compatible queries in SMF 2, IOW they are only compatible with SMF 1.1 not 2.0.

Title: Re: PhpMyDirectory and SMF2
Post by: H on July 31, 2009, 10:16:15 AM

Marking this as solved. As Dragooon says, the problem is because phpmydirectory is only compatible with SMF 1.1.x

Title: Re: PhpMyDirectory and SMF2
Post by: KalkanPrince on August 02, 2009, 03:04:42 PM

Thanks, PHPMYdirectory have modded their code for SMF2 now due to your tips :)

Simple Machines Community Forum

Customizing SMF => Bridges and Integrations => Topic started by: KalkanPrince on July 26, 2009, 08:20:39 AM