Yeah.. I posted this at the SMF forum and they told me to ask you about this...
Since the update to 1.1 and TP 0.9.7, people cannot register... they get
QuoteDatabase Error
Please try again. If you come back to this error screen, report the error to an administrator.
I thought the upgrade to 1.1.1. would maybe fix, but it did not... and yep, I upgraded the database and all that...
Help?
Well registration really has nothing at all to do with Tiny Portal.
Can you post a link to the thread on SMF where the person said to come here? Cos I would like to see their evaluation of the situation in the hopes of better understanding what the problem could be. And hopefully getting a resolve
Can you check your error log and post any/all entries which seem to be associated with this (I believe they 'should' all be labeled as errors by 'Guest' if they're just trying to register).
And if you had Felblog installed, uninstall Felblog (if not possible) you have to remove the code Felblog adds to the files and try again.
There have been some issues with Felblog and registration and with the verification imgages, and when felblog was removed, every thing went back to normal.
Alright... here we go...
This is their thread: http://www.simplemachines.org/community/index.php?topic=135434
I am checking the error logs now to post to you guys...
And yes, I used to have Felblog, but I removed all mods because I reinstalled the board from zero and then added the old database to it when RC3 became SMF 1.1. :)
Here comes the error:
QuoteApply Filter: Only show the error messages of this member Guest Today at 08:57:16 AM
Apply Filter: Only show the error messages of this IP address 201.95.76.170 Apply Filter: Only show the error messages of this session 32a179e7b901d520a7ee919a3135a6df
Apply Filter: Only show the error messages of this URL http://www.khaotikdezirez.com/index.php?action=register2
Apply Filter: Only show the errors with the same message
Database Error: 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 ' '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '',' at line 3
File: /home/khaotikd/public_html/Sources/Subs-Members.php
Line: 788
And also
QuoteApply Filter: Only show the error messages of this member Guest Today at 08:57:16 AM
Apply Filter: Only show the error messages of this IP address 201.95.76.170 Apply Filter: Only show the error messages of this session 32a179e7b901d520a7ee919a3135a6df
Apply Filter: Only show the error messages of this URL http://www.khaotikdezirez.com/index.php?action=register2
Apply Filter: Only show the errors with the same message
8: Undefined index: shopRegAmount
File: /home/khaotikd/public_html/Sources/Subs-Members.php
Line: 708
The Shop mod wasn't fully/correctly installed.
It didn't create the an entry in the database for the amount to be credited on registration (and it MAY not have supplied other entries needed for Shop functionality).
In a php block to appear anywhere (for admin only - no groups checked) enter:
global $db_prefix;
db_query("INSERT IGNORE INTO {$db_prefix}settings (`variable`, `value`) VALUES ('shopRegAmount', '0')", __FILE__, __LINE__);
That's the line right out of the the installScript.php for the latest Shop.
Activate the block and go to a page where it would/should 'show'. It 'shouldn't' output anything, but you can have the block show title/frame just for feedback that it loaded.
Then de-activate the block.
(Alternately, you could go in via phpMyAdmin and run that SQL).
Of course, the fact that this didn't execute for your shop install might indicate other problems with the functionality of that mod.
I went via SQL....
It did not execute, it gave me the following:
MySQL : Documentation
#1064 - 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 'global $db_prefix' at line 1
That's because that is part of the php.
The query is just part of the longer line and you have to replace the $db_prefix with the prefix used in your database (probably 'smf_').
If it is, then the SQL you want to use will be -
INSERT IGNORE INTO smf_settings (`variable`, `value`) VALUES ('shopRegAmount', '0')
Note the difference between back-ticks and single-quotes.