FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » URGENT, Crying right now T_T (Upgraded to 3.01 and now no one can register )
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
URGENT, Crying right now T_T [message #162948] Tue, 07 September 2010 09:01 Go to next message
slowmo is currently offline  slowmo   Singapore
Messages: 22
Registered: July 2009
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
include/theme/default/db.inc:95
include/theme/default/db.inc:166
ft.3ezy.com/adm/admuser.php:335
) near "=": syntax error: HY000
Query: SELECT * FROM fud3ez_users WHERE id=
_POST: array ( 'S' => '4070333cb518ad665a464039fa8a26fa', 'SQ' => 'e71b0c5594b23d417046898eb0bb2128', 'usr_login' => 'someuse', 'usr_email' => '', 'usr_search' => 'Search', )
Server Version: 3.3.7
[Referring Page] http://ft.com/adm/admuser.php?rid=2&S=4070333cb518ad665a464039fa8a 26fa&SQ=e71b0c5594b23d417046898eb0bb2128


i am using sqlite. The above happened when i manually try to create user for some using adm panel

please help.. man my woes started ever since i upgraded to fudforum 3.0 >.<

i have tons of errors . heres more.


this happens to users who are coming to register

ft.com/index.php:108
ft.com/index.php:115
ft.com/theme/default/login.php:653
fty.com/index.php:1229
) near "=": syntax error: HY000
Query: UPDATE fud3ez_users SET last_login=1283863010 WHERE id=
_GET: array ( 't' => 'login', )
_POST: array ( 'login' => 'someone0', 'password' => 's9222734j', 'S' => 'c38d1ddc34578087c3599719282a8e86', 'SQ' => '0', 'adm' => '', )
Server Version: 3.3.7
[Referring Page] http://f,...com/index.php?t=login&rid=0&S=c38d1ddc34578087c35997 19282a8e86


PLease help me resolve this asap. I am advertising my board , many people it seems wanted to register but got knoecked off.

pls tell me if you know whats wrong exactly right now. I am asking someone to build the entire forum again on another software for me. he is working on it now.

[Updated on: Fri, 10 September 2010 15:37]

Report message to a moderator

Re: URGENT, Crying right now T_T [message #162949 is a reply to message #162948] Tue, 07 September 2010 10:52 Go to previous messageGo to next message
slowmo is currently offline  slowmo   Singapore
Messages: 22
Registered: July 2009
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
I read about a similar problem here http://fudforum.org/forum/index.php?t=msg&th=119420&start=0& but mine was sqlite
So i sed the admin panel and backed up then imported again. Because googling revealed this is how sqlite can be repaired, backup and restore.

Now there is only one problem I have category and in this category there are 5 forums right now, but only displays. I have checked the group manager and permissions are all set same as other forums, they all show but these 4 dont. this only happens in one category. any help please?
Re: URGENT, Crying right now T_T [message #162950 is a reply to message #162949] Tue, 07 September 2010 11:22 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3624
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
Try to run the consistency checker (in the ACP).

What version are you running, 3.0.0 or 3.0.1?
Re: URGENT, Crying right now T_T [message #162951 is a reply to message #162950] Tue, 07 September 2010 12:11 Go to previous messageGo to next message
slowmo is currently offline  slowmo   Singapore
Messages: 22
Registered: July 2009
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
i am using 3.0.1. I have run consistentcy checker and optimize many many times. no use.

I still get these errors and permissions dont seem to work. The group with pivileges to create topic cannot create anymore
Query: SELECT seq FROM fud3ez_tv_13 ORDER BY seq DESC LIMIT 1
_GET: array ( 't' => 'thread', 'frm_id' => '13', 'rid' => '0', 'S' => '995ce273a2ad3574fe49f20d3091cbc4', )
Server Version: 3.3.7
[Referring Page] http://ft....com/index.php?t=index&rid=0&S=995ce273a2ad3574fe49f2 0d3091cbc4

ALSO Fatal error on trying to add Leader . its not really needed but this whole wrror thing has to be fixed. pls.

[Updated on: Fri, 10 September 2010 15:38]

Report message to a moderator

Re: URGENT, Crying right now T_T [message #162952 is a reply to message #162951] Tue, 07 September 2010 12:21 Go to previous messageGo to next message
slowmo is currently offline  slowmo   Singapore
Messages: 22
Registered: July 2009
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
ok my bad on the permissions. i feel stupid, in all the craziness i forgot to check permissions on the group for all forums is selected. phew!, but I still cant make group leader (i dont want to touch that button again) and errors dont stop T_T
Re: URGENT, Crying right now T_T [message #162953 is a reply to message #162952] Tue, 07 September 2010 15:08 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3624
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
I've just registered on your site and everything works as expected.

Please explain to us in detail what the problem is. What do I need to do to see it?
Re: URGENT, Crying right now T_T [message #162954 is a reply to message #162953] Tue, 07 September 2010 22:06 Go to previous messageGo to next message
slowmo is currently offline  slowmo   
Messages: 22
Registered: July 2009
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
thanks naudefj for helping me and responding so fast. I know its free software so I should not ask for much. I was able to fix the permissions. Seems like giving the anonymous group in group management all the relevant permission does not work. I have to select each and every forum and edit the anon user.

There are a couple of things going on. I am able to fix them one at a time. I can give you admin access to see the error logs and also try to add me "Vangel" as a group leader. Last I checked it gave me Fatal Error. I have done consistency check and sql optimize many times bu the result is same.

I will set your status to admin. go to groups and then select manage leaders. In the next page you get to search a user. enter a username, any, and you will see fata error. Also see my log files and sql log. I do not want you to waste time on this. Whatever you can do please try. I will send you virtual cake and beer ^^

thank you sooo much Smile
p.s. i set you up as admin.
Re: URGENT, Crying right now T_T [message #162955 is a reply to message #162954] Wed, 08 September 2010 11:24 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3624
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
OK, I've logged on:

1. Most of the errors you see in the error log are trivial and can be ignored.

2. When trying to add group leaders, SQLite gives error "cannot commit transaction - SQL statements in progress". This is obviously a bug!

I'll get back to you on pt 2 later.

Regards.

Frank
Re: URGENT, Crying right now T_T [message #162957 is a reply to message #162955] Thu, 09 September 2010 02:30 Go to previous messageGo to next message
slowmo is currently offline  slowmo   
Messages: 22
Registered: July 2009
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
thanks naudefj. here's the virtual cake and beer
/pass beer, cake
Very Happy
I dont know if I should make another thread for this so I ask here. Is it possible for members to email to a specific forum and create topics, replies? maybe setting up different email for different forums?
thanks again
Re: URGENT, Crying right now T_T [message #162958 is a reply to message #162957] Thu, 09 September 2010 02:38 Go to previous messageGo to next message
slowmo is currently offline  slowmo   
Messages: 22
Registered: July 2009
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
.. and yeah the RSS feed is bugged. It dumps the feed.php file for download to the browser, when i open the file the feed content is there. But for some reason maybe the header is not being sent? i tried other site feeds and they display in browsers feed reader ok.
Re: URGENT, Crying right now T_T [message #162962 is a reply to message #162957] Thu, 09 September 2010 15:38 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3624
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
slowmo wrote:
Is it possible for members to email to a specific forum and create topics, replies? maybe setting up different email for different forums?


No directly no. You will have to setup external mailing lists (one per forum) and use the Mailing List Manager to sync your forms with the lists.

Kwoteer:
.. and yeah the RSS feed is bugged. It dumps the feed.php file for download to the browser, when i open the file the feed content is there. But for some reason maybe the header is not being sent? i tried other site feeds and they display in browsers feed reader ok.


Can you please give us an example of one that works and a FUDforum feed that doesn't?

Re: URGENT, Crying right now T_T [message #162963 is a reply to message #162962] Thu, 09 September 2010 15:59 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3624
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
Here is a patch for the SQLite problem:
http://fudforum.svn.sourceforge.net/viewvc/fudforum/tags/fud3_0_1/install/f orum_data/sql/pdo_sqlite/db.inc?r1=4945&r2=4998

After applying it, you need to rebuild your themes.
Re: URGENT, Crying right now T_T [message #162964 is a reply to message #162962] Fri, 10 September 2010 07:11 Go to previous messageGo to next message
slowmo is currently offline  slowmo   Singapore
Messages: 22
Registered: July 2009
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
naudefj wrote on Thu, 09 September 2010 15:38
slowmo wrote:
Is it possible for members to email to a specific forum and create topics, replies? maybe setting up different email for different forums?


No directly no. You will have to setup external mailing lists (one per forum) and use the Mailing List Manager to sync your forms with the lists.

Kwoteer:
.. and yeah the RSS feed is bugged. It dumps the feed.php file for download to the browser, when i open the file the feed content is there. But for some reason maybe the header is not being sent? i tried other site feeds and they display in browsers feed reader ok.


Can you please give us an example of one that works and a FUDforum feed that doesn't?



I don't have a working one atm. You can see in the same forum all RSS feeds are bugged. they push to the browser as download. and are marked as feed.php file.

here is one that is RDF and works
http://images.gonzb.com/newsbb/rdf.php?mode=m&l=1&basic=1&frm=5 &n=10

older fud install.

thanks for the patch too, ill try it tonight.
Re: URGENT, Crying right now T_T [message #162966 is a reply to message #162964] Fri, 10 September 2010 10:49 Go to previous messageGo to next message
Ernesto is currently offline  Ernesto   Sweden
Messages: 413
Registered: August 2005
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
RDF on http://ft.3ezy.com works fine for me with firefox and opera, however it does not work with chrome

[Updated on: Fri, 10 September 2010 10:51]

Report message to a moderator

Re: URGENT, Crying right now T_T [message #162967 is a reply to message #162966] Fri, 10 September 2010 15:41 Go to previous message
slowmo is currently offline  slowmo   Singapore
Messages: 22
Registered: July 2009
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
yes i tried it in chrome and you are right, i dont know the reason still. :/ I haven't tried the patch yet,because i want to be sure i got everything backed up and ready for revert in case things go south. I think my install is fudged >.<
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Board Hacked?
Next Topic: post.php parse error with safe mode FUD install
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Oct 21 04:47:09 EDT 2017

Total time taken to generate the page: 0.00916 seconds