Simple Machines Community Forum

After reading everything i still get an error:
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /var/www/temp/Sources/Subs.php on line 232

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /var/www/temp/Sources/Load.php on line 40

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/temp/Sources/Load.php on line 42

Notice: Undefined index: time_format in /var/www/temp/Sources/Load.php on line 176

Notice: Undefined index: theme_guests in /var/www/temp/Sources/Load.php on line 657

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /var/www/temp/Sources/Subs.php on line 232

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/temp/Sources/Load.php on line 683

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/temp/Sources/Load.php on line 693

Notice: Undefined index: theme_url in /var/www/temp/Sources/Load.php on line 700

Notice: Undefined index: images_url in /var/www/temp/Sources/Load.php on line 701

Notice: Undefined index: theme_dir in /var/www/temp/Sources/Load.php on line 702

Notice: Undefined index: smiley_sets_known in /var/www/temp/Sources/Load.php on line 721

Notice: Undefined index: smiley_sets_default in /var/www/temp/Sources/Load.php on line 721

Warning: array_unshift(): The first argument should be an array in /var/www/temp/Sources/Load.php on line 762

Notice: Undefined index: theme_dir in /var/www/temp/Sources/Load.php on line 822

Notice: Undefined index: default_theme_dir in /var/www/temp/Sources/Load.php on line 824

Notice: Undefined index: default_theme_dir in /var/www/temp/Sources/Load.php on line 831
index

I applied the hack as described. The forum registration works fine, it only goes wrong when a user tries to register when checking out (thus using the phpshop register function). It seems to go wrong on this line require ($smf_path."/SSI.php");

I'm using phpshop1.2pl3 and smf 1.0.5 and mambo 4.5.2.3 on php 4.3.10 and mysql 4.1

QuoteAfter reading everything i still get an error:

Where are you getting these errors?  (Main page, logging in, registering)

What version of the bridge are you using?

Quote from: Orstio on July 03, 2005, 04:42:07 PM

QuoteAfter reading everything i still get an error:

Where are you getting these errors?  (Main page, logging in, registering)

What version of the bridge are you using?

I get the errors when i try to check out items as a guest. Phpshop tells me to register, and then after i click "Send Registration" i get those errors. I'm using the latest bridge (3.19a). Here's my site so you can check it for yourself: http://risperdal.student.utwente.nl/mambo/index.php

As i said there are no problems with the bridge the forum just works fine. I only get errors when a users tries to register via phpshop hack

Thanks for the details, that helps a lot.  :)

Are there any errors in your SMF admin error log that might help?

If you change to "Bridge Registration" in the forum component config, does that also give you the same errors?

Quote from: Orstio on July 03, 2005, 06:37:27 PM
Thanks for the details, that helps a lot.  :)

Are there any errors in your SMF admin error log that might help?

If you change to "Bridge Registration" in the forum component config, does that also give you the same errors?

No errors at all in the admin error log. Changing the registration modus to Bridge gives the same errors.

QuoteChanging the registration modus to Bridge gives the same errors.

Aha!  Now there's a clue.  :)

What happens if you remove the line from your first post:

require ($smf_path."/SSI.php");

Quote from: Orstio on July 03, 2005, 07:30:51 PM

QuoteChanging the registration modus to Bridge gives the same errors.

Aha!  Now there's a clue.  :)

What happens if you remove the line from your first post:

Code Select Expand

require ($smf_path."/SSI.php");

Fatal error: Call to undefined function: db_query() in /var/www/mambo/administrator/components/com_phpshop/html/shop.registration.php on line 206

I've been trying somethings and i dont get why the require of SSI.php gives and error in shop.registration.php and not in mod_smf_login.php do you have any idea?

I have seen something like this before.  It's because SSI.php should only be called once, but that is usually solved by the surrounding "if" structure.

I'll work on this, and post something up within the next week.  I have to make the PhpShop hack compatible with SMF 1.1b3 anyway, and I want to take a look at more of Soeren's code.

Thanks for the report, and the information.  That will be key to fixing this.  :D

For the record I'm having exactly the same problem:

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/hereford/public_html/forum/Sources/Subs.php on line 232

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/hereford/public_html/forum/Sources/Load.php on line 40

etc.

URL to have a look is: http://www.herefordwaldorfschool.org/Mambo/component/option,com_phpshop/Itemid,59/

I'm using a wrapped SMF forum with Bridge registration

The software I'm running is as follows:
Mambo v4.5.2.3
SMF v1.0.5
SMF-Bridge v3.19a
Mambo php-shop v1.2-pl3

I'd be really grateful for a solution.

BTW - I really like SMF - its a very nice piece of work  :)

What happens if you change the require ($smf_path."/SSI.php");
to read require_once ($smf_path."/SSI.php");

{edit:  oops....   missedthe underscore the first time around.}

Took a while to figure out the function is called "require_once" not "requireonce".

Making this chance makes no difference to the error.   :(

Hi,

I'm having this exact same problems and after upgrading mambo-phpShop to pl3. Soren has changed the checkout forms. Maybe something not being passed correctly in the new version??

I only discovered the error when a kind shopper emailed me to say that they were having problems.

In the meantime I have disable the forum and reverted back to the standard login module.

Scott

Orstio,

Any thoughts yet? I've even got phone calls asking when the my sites forum will be back up and running. I'd love to have both my shoppers and forum users happy.

I'll keep checking back for updates. Is there anything that I could be looking at that might help. I'm no great coder but I may be able to do something.

Scott

I'm trying, but it looks like the phpShop component is going to need more changes in order to work with this.  :(

Orstio,

I have been trying to figure this out a bit. I have SMF 1.0.5 and version 3.18 of the bridge (just downloaded 3.19 and will try it).

On my test server I have managed to eliminate the whole page of errors just down to the two posted by Elephant Gerald by inserting the last line  before the </body> in the template. Yes, somehow things were working before without it.

Now I have also compared the bridge login module code to the shop.registration.php hack. The code is nearly identical. So much so that I actually cut the code from the login module and pasted it into the shop.registration.php file. No luck though... still these two errors.

What else in the shop check out could be calling a smf query??

Still looking.

Scott

The shop module is not what is calling the query.  It is SMF's SSI.php, and for some reason, phpShop is wiping the variables after SSI has returned them to Mambo.

I'll figure out where this is going wrong, but it will take some time.

Orstio,

Thanks for looking into this. I have updated the bridge with the same results. This is very strange.

The register code is identical in the shop modele.

I hope you can figure this one out as I have no idea and not sure how to track where the error is.

Thanks

Scott

Orstio,

Any more thoughts???

Scott

Well, I have only one idea left of what may be going on.  It is very strange, because I have tried quite a few things.

What you may wish to do in the meantime is make your PhpShop available only to registered members.  I know that sounds horrible, but it is better than shutting down your forum completely, and will still allow both the shop and forum to function.

I will find a solution, but I can't guarantee a time-frame.

Orstio,

I have sacraficed the forum over the shop. I have been trying to get the Mambohack integration to work as well, with no luck on that front either.

I look forward to a solution.

Scott

QuoteI have sacraficed the forum over the shop. I have been trying to get the Mambohack integration to work as well, with no luck on that front either.

I suggest not using that, because it will modify your forum copyright, which is a violation of your license agreement.

I have a look through the installation script. It definately changes the copyright. Not to hard to take out that change from the install.

I'm just desperate to get the forum up and running again.

Scott

Well I have done a work around to use the bridge with mambo-phpShop. It does not use the hack that is available.

Basically I have disabled user registration in the checkout. When a new custmer comes to the shipping address they are asked to login or register using the bridge login module.

Once they register they then are presented with the standard phpShop shipping information page.

Works ok but it does add an additional step in the checkout.

Scott

Is there any chance of posting the code you've mangled?  :D

Gerald,

I'll put together what I have done. I've just had my first complaint regarding the now "awful" (quoted) shopping cart. One user has found the mangled registration a real pain...

The additional step in the checkout process is a pain.

Scott

Did anyone ever find a answer to this problem?  I am encountering the same thing using the SMF Bridge from Mambo, and PHPShop.  I can't get the user to add to the SMF User database, so then anyone using the login module can't access order info.  Thanks for any help

The bridge for SMF 1.1 RC2 should work for this.  However, the users that register through PhpShop won't be added to SMF until they login the first time.

Quote from: Orstio on January 03, 2006, 09:22:31 PM
The bridge for SMF 1.1 RC2 should work for this.  However, the users that register through PhpShop won't be added to SMF until they login the first time.

I currently have RC1 installed, with the applicable version of the bridge.  Is this a seamless upgrade?  Or do I need to remove anything/reinstall and files?  Thanks!

You can just upgrade SMF.

Download the new bridge from here:

http://www.simplemachines.org/community/index.php?topic=63182.0

You are probably best to uninstall the two components, and the login module, and then install the new bridge.  Don't forget to configure, and don't forget the code in your template.

Something users that are migrated from the PhpShop registration will notice is that when they try to login to the forum, they will be faced with the message "Password security has recently been upgraded.  Please login again."  This is perfectly normal.  They will be logged in on the next attempt.