Tim's dashboard

Scott Fleckenstein replied on June 06, 2008 20:24 to the problem "Helpcenter Install" in Get Satisfaction:

Tim,

The sprinkles user may not have access to modify the schema for the database.

What is the result of running the following:

mysql -usprinkles -p sprinkles -e 'SHOW GRANTS FOR CURRENT_USER;'

That will help us confirm your DB is setup correctly.

Thanks,
Scott

Tim replied on June 06, 2008 19:48 to the problem "Helpcenter Install" in Get Satisfaction:

I am on a shared hosting account and do have a user called sprinkles. Still getting the error message above when uploading schema to sprinkles sql database. Does something need to be changed in the schema file?

ezrakilty replied on June 03, 2008 17:26 to the problem "Helpcenter Install" in Get Satisfaction:

Tim: What Scott says may help. Also, are you sure that you have a MySQL user called 'sprinkles'? If you're using a shared hosting account, you may have been given a MySQL username that's different from that one.

Scott Fleckenstein replied on June 02, 2008 23:39 to the problem "Helpcenter Install" in Get Satisfaction:

Hi Tim,

It looks like you just have your permissions setup incorrectly on your mysql database.

I would recommend install phpMyAdmin and then granting access to the sprinkles user on your DB.

One way to test your setup outside of helpcenter itself, launch the mysql command line client using the credentials you provided to your Helpcenter config. Something like:

mysql -usprinkles -p sprinkles -e 'select * from site_settings'

Hope that helps,
Scott

Tim replied on June 02, 2008 22:36 to the problem "Helpcenter Install" in Get Satisfaction:

Any advice, still stuck here?

Jauder Ho replied on May 30, 2008 21:26 to the problem "Trouble installing helpcenter" in Get Satisfaction:

Scott,

Prehaps you should include a blank directory by default and rewrite the directions to change perms/ownership. This did trip me up somewhat the first time.

Tim replied on May 29, 2008 23:07 to the problem "Helpcenter Install" in Get Satisfaction:

Amy,

Thank you, I tried the steps in the previous explanation, but am still stuck.

A comment on the problem "Helpcenter Install" in Get Satisfaction:

Ok. I'll get a developer in here to help you out. – Amy Muller, on May 29, 2008 23:00

Tim replied on May 29, 2008 21:45 to the problem "Helpcenter Install" in Get Satisfaction:

Here is the error message i'm receiving when uploading the sprinkles_schema:

SQL query:

--
-- Dumping data for table `site_settings`
--
LOCK TABLES `site_settings` WRITE ;

MySQL said:

#1044 - Access denied for user 'sprinkles'@'%' to database 'sprinkles'

Amy Muller replied on May 29, 2008 19:25 to the problem "Helpcenter Install" in Get Satisfaction:

Hi. I believe there's an explanation on this topic - http://getsatisfaction.com/satisfacti...

Tim reported a problem in Get Satisfaction on May 29, 2008 19:11:

Helpcenter Install

I'm getting a blank page on handle-admin-findsite.php after the authorization process. Any thoughts?

Scott Fleckenstein replied on May 29, 2008 06:44 to the problem "Trouble installing helpcenter" in Get Satisfaction:

Oops!

I'll make sure to add that into the instructions on the help center page.

Sorry about the frustration!

Marat Levit replied on May 29, 2008 06:33 to the problem "Trouble installing helpcenter" in Get Satisfaction:

Hey Scott,

Thanks for your help. I had never made the templates_c folder. I had read that I needed the folder in the INSTALL file which came with the helpcenter, but it was never mentioned that this folder was needed in the installation instructions (http://getsatisfaction.com/tradetoday...).

Works well now, thanks

Scott Fleckenstein replied on May 29, 2008 06:18 to the problem "Trouble installing helpcenter" in Get Satisfaction:

Marat, having a blank screen on admin-findsite.php has been almost invariably bad permissions on the templates_c directory that smarty uses.

You need to make sure that templates_c is writable by your webserver process.

Short circuiting through directly to the admin page without first going through admin-findsite will fail in all sorts of ways, like you've seen. During that step we record the where you are serving the php from which is used to create the callbacks into your system from our side.

You may need to clear out the site_settings table since you went directly to the admin page.

-Scott

Tim started following the problem "Trouble installing helpcenter" in Get Satisfaction.

Tim marked one of Amy Muller's replies in Get Satisfaction as useful. Amy Muller replied to the problem "Can't tell if i've got admin status or not?".

A comment on the problem "Can't tell if i've got admin status or not?" in Get Satisfaction:

Hi Tim -- Sorry about that. To clarify, you need to be in your company's GS area to see the admin link, eg: http://getsatisfaction.com/yourcompany – Amy Muller, on May 27, 2008 19:50

Tim replied on May 27, 2008 19:46 to the problem "Can't tell if i've got admin status or not?" in Get Satisfaction:

Amy,

I'm looking at the login screen, it says' i'm logged in and don't see an Admin link? Strange, because last night I found my way into the admin panel, but now it's not showing up.

Thanks,

Tim

Amy Muller replied on May 27, 2008 17:02 to the problem "Can't tell if i've got admin status or not?" in Get Satisfaction:

For future reference to other people with this question...

If you are set as an Admin, you should see an "Admin" link in the top bar when signed into Get Satisfaction and in your company's Get Satisfaction area:


Glad this has been resolved for you, Tim!

A comment on the problem "Can't tell if i've got admin status or not?" in Get Satisfaction:

Sure thing. Call on me if you have any questions! – Eric Suesz, on May 27, 2008 04:18