For the record:
- I am not, at this time, looking for support because atm, everything is installed and working.
- I am interested in answers to small related questions.
Quick Description of current situation:
I just installed eFiction 3.5.3 under localhost and at first glance it looked like everything went fine-. That is until I decided I should learn the options available to change settings.
I read the forums, and the wiki to find out why I couldn't get access to any of admin settings, let alone find the admin link that's supposed to be on the main nav.
It was pointed out by someone that I needed to go into the actual mysql database, in my case efic database and modify the Table: fanfiction_authorprefs by changing uid (user id) #1's level from 0 to 1. That worked perfect-- thanks. I have access to everything thus far.
I Noticed the following:
I noticed a few things while fixing this admin privileges problem. Firstly that in the fanfiction_authors table that was created during install; that there was only a single username listed, the one that I had entered while installing, and that was labeled with uid #1. There is no uid #0 in this table.
Secondly, in the fanfiction_authorprefs table, there are two uid's listed here. Them being #0 and #1. Prior to applying the above fix, the uid #0 was already set with level 1. and the uid #1 had the level set to 0.
I assume, the uid #0 with level 1 already set, is what I was supposed to be given during install, but instead was linked from the fanfiction_authorprefs table uid #1 to fanfiction_author table uid #1. Thus being given no admin privileges and a seemingly useless uid #0 in the fanfiction_authorprefs table (unless this uid #0 is solely used by the efic php script itself).
Quick Questions:
- Why is that step even needed?
- Is it because of a difference between mysql 4 and 5? php 4 or 5?
- Or is it because the install files themselves need updating to overcome this?
A Suggestion:
- A README.txt / wiki update to reflect this fix if others have had this occur since this is a relatively quick and easy fix to apply installers find themselves without admin status fresh out of the box, so to speak.
For Reference:
- Apache 2.2.11
- PHP 5.3.0 w/ error display turned off.
- Mysql 5.1.36
« modified for clarity, typos, and prettiness »
It sounds like you have an issue with your server where mySQL isn't returning an insert id when new items are inserted into the database. Either this was a hiccup or it's something with your server configuration.
Must be my server configuration then, because after 5 test installs, I get the same results. ie: installed with no admin priv upon login of the only user available.
Though I have no clue how to run this down.
I'll try to downgrade my wamp with their addon's: mySQL 4.x and php4 and apache 2.0, then proceed with a 6th install tonight to see if that helps, but if that's the case then i'll end up having to lose my other php script access (phpBB, mediawiki, wordpress, joomla etc.)
My live site is running php 5.2.14 and mysql 5.0.45, and I'm not having any issues with 3.5.3. Are you sure you're at 3.5.3 and not 3.5.2? We updated the mysqli functions in 3.5.3 to accommodate some changes in recent versions of php. That may be your issue.
Hmm... I did some research on php's site. Seems to be a problem a lot of people are having with the new mysqli stuff. I've made a couple changes to the mysqli_functions.php file and put it in the SVN. Try that.
