Gallery 3.0 Beta 2 Feedback

floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Sun, 2010-01-10 01:11

Use the forgot password link on the login page.

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team

 
Martinswar
Martinswar's picture

Joined: 2007-10-19
Posts: 18
Posted: Sun, 2010-01-10 01:24

It won't work, it only flashes and does nothing.

 
talmdal

Joined: 2006-12-06
Posts: 358
Posted: Sun, 2010-01-10 02:07

run the following mysql query:

Quote:
update ${DB_PREFIX}users set password='O34c384a78a5d83403d5ddd80ed077165ef7' where id=2;

which should set the password to "admin"
http://www.timalmdal.com

 
Martinswar
Martinswar's picture

Joined: 2007-10-19
Posts: 18
Posted: Sun, 2010-01-10 20:24
Quote:
update ${DB_PREFIX}users set password='O34c384a78a5d83403d5ddd80ed077165ef7' where id=2;

I did as requested in the post above and it came up with the error below....

Quote:
Error
SQL query:

UPDATE ${DB_PREFIX}users SET PASSWORD = 'O34c384a78a5d83403d5ddd80ed077165ef7' WHERE id =2

MySQL said:

#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 '{DB_PREFIX}users set password='O34c384a78a5d83403d5ddd80ed077165ef7' where id=2' at line 1

 
talmdal

Joined: 2006-12-06
Posts: 358
Posted: Sun, 2010-01-10 21:05

@Martinswar: Replace the ${DB_PREFIX} with what every prefix you used to when you installed gallery3. You might not have specified a prefix, so you would just use user as the table name. If you used something like g3_ as the prefix then you would use g3_user

http://www.timalmdal.com

 
Martinswar
Martinswar's picture

Joined: 2007-10-19
Posts: 18
Posted: Thu, 2010-01-14 17:10

I know I named it gallery

Can I PM you my login info so, you can help me rectify it?

Or, is there a way I can reinstall it without loosing my pic's and indexed links?

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Thu, 2010-01-14 17:19

look in your gallery/var/database.php file. That lists exactly what's being used and what you told Gallery to connect to your database with.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
Martinswar
Martinswar's picture

Joined: 2007-10-19
Posts: 18
Posted: Mon, 2010-01-25 01:48

I did see what I needed to see there but using the info still won't take any effect, there must be something I did wrong because I noticed it is mysqli instead of mysql.

Please check out the qoute below, you might be able to find what I am missing out.

Pretenders are people who lack self confidence...

Quote:
<?php defined("SYSPATH") or die("No direct script access.");

/**
* @package Database
*
* Database connection settings, defined as arrays, or "groups". If no group
* name is used when loading the database library, the group named "default"
* will be used.
*
* Each group can be connected to independently, and multiple groups can be
* connected at once.
*
* Group Options:
* benchmark - Enable or disable database benchmarking
* persistent - Enable or disable a persistent connection
* connection - Array of connection specific parameters; alternatively,
* you can use a DSN though it is not as fast and certain
* characters could create problems (like an '@' character
* in a password):
* 'connection' => 'mysql://dbuser:secret@localhost/kohana'
* character_set - Database character set
* table_prefix - Database table prefix
* object - Enable or disable object results
* cache - Enable or disable query caching
* escape - Enable automatic query builder escaping
*/
$config['default'] = array(
'benchmark' => false,
'persistent' => false,
'connection' => array(
'type' => 'mysqli',
'user' => 'nigeriaf_XXXXX',
'pass' => 'XXXXXXXX',
'host' => 'localhost',
'port' => false,
'socket' => false,
'database' => 'nigeriaf_gallery'
),
'character_set' => 'utf8',
'table_prefix' => '',
'object' => true,
'cache' => false,
'escape' => true
)

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Mon, 2010-01-25 06:42
Quote:
'table_prefix' => '',

The prefix is set to nothing.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
Martinswar
Martinswar's picture

Joined: 2007-10-19
Posts: 18
Posted: Mon, 2010-01-25 16:45

nivekiam,

Please do you have an example for me, of what the table_prefix should be or look like?

Thanks for your immediate and possitive response so far.

________________________________________________
Pretenders are people who lack self confidence...

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Mon, 2010-01-25 17:49

Anything you want, but from your database.php file you didn't enter anything so G3 didn't use a prefix. So if you were to browse your database, which is named nigeriaf_gallery, not just "gallery", using something like phpMyAdmin, you'd see the names of the tables G3 uses without any prefix.

The prefix isn't a big deal unless you're using the same database with multiple applications. Then the prefix becomes helpful to 1) make sure that table names are unique between applications and 2) you can easily identify which tables go with which application. Without a prefix and if you share the same database with other applications, like WordPress, you run the risk of the same table being used by both applications which would most likely cause each application to stop working.

If you need more help, please start a new thread. This thread is for general feedback and I'm having a hard time following just what you need.

http://gallery.menalto.com/forum/97
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
Martinswar
Martinswar's picture

Joined: 2007-10-19
Posts: 18
Posted: Mon, 2010-01-25 23:48

Yeah, the prefix should have been nuke related tables, I sure will start a new thread for that.
________________________________________
Pretenders are people who lack self confidence...