Webpanel Problems

Arrow768 · **Author**

All the posts that do not belong into the webpanel thread are moved to this thread

Quote:

Originally Posted by Arrow768

You can download a Version of the Webpanel here

A very short installation guide:
* Upload all the files to your Webserver
* Edit the application/config/database.php to point to the store db (dont forget to remove the [])
* Enter a encryption key in the application/config/config.php
* Import the application/sql/ion_auth.sql into the store database
* Login to the webpanel with the default login details (user:[email protected] pass:password)
* Change the login details via the webpanel (NOT WITH PHPMYADMIN)
* Dont forget to update your webpanel to the latest version when the repo is online again

Some requirements:
A LAMP installation with php 5.4 (5.3 should work too) and enabled short open tags

htcarnage · 07-25-2013 , 02:52 Webpanel Problems

I get the following when I try to login using the default username and pw. I have imported ion_auth successfully

Code:

Error Number: 1146
Table 'notoriou_store.store_users' doesn't exist
SELECT * FROM (`store_users`) ORDER BY `credits` desc
Filename: /home/notoriou/domains/notoriousclan.com/public_html/store/models/users_model.php
Line Number: 36

justicex333 · 07-26-2013 , 10:47 Re: Store WebPanel

can some body help me?

1.

PHP Code:


			
Fehler
SQL-Befehl:

CREATE TABLE users(

id INT NOT NULL IDENTITY( 1, 1 ) ,
ip_address VARCHAR( 16 ) NOT NULL ,
username VARCHAR( 100 ) NOT NULL ,
PASSWORD VARCHAR( 80 ) NOT NULL ,
salt VARCHAR( 40 ) ,
email VARCHAR( 100 ) NOT NULL ,
activation_code VARCHAR( 40 ) ,
forgotten_password_code VARCHAR( 40 ) ,
forgotten_password_time INT,
remember_code VARCHAR( 40 ) ,
created_on INT NOT NULL ,
last_login INT,
active INT,
first_name VARCHAR( 50 ) ,
last_name VARCHAR( 50 ) ,
company VARCHAR( 100 ) ,
phone VARCHAR( 20 ) ,
PRIMARY KEY ( id ) ,
CONSTRAINT users_check_id CHECK (
id >=0
),
CONSTRAINT users_check_active CHECK (
active >=0
)
);

MySQL meldet: Dokumentation

#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 'IDENTITY(1,1),
    ip_address varchar(16) NOT NULL,
    username varchar(100) NO' at line 2

2-

PHP Code:


			
Fehler
SQL-Befehl:

CREATE TABLE  "users"(

 "id"SERIAL NOT NULL ,
 "ip_address"inet NOT NULL ,
 "username"VARCHAR( 100 ) NOT NULL ,
 "password"VARCHAR( 80 ) NOT NULL ,
 "salt"VARCHAR( 40 ) ,
 "email"VARCHAR( 100 ) NOT NULL ,
 "activation_code"VARCHAR( 40 ) ,
 "forgotten_password_code"VARCHAR( 40 ) ,
 "forgotten_password_time"INT,
 "remember_code"VARCHAR( 40 ) ,
 "created_on"INT NOT NULL ,
 "last_login"INT,
 "active"INT4,
 "first_name"VARCHAR( 50 ) ,
 "last_name"VARCHAR( 50 ) ,
 "company"VARCHAR( 100 ) ,
 "phone"VARCHAR( 20 ) ,
PRIMARY KEY (  "id" ) ,
CONSTRAINT  "check_id" CHECK (
id >=0
),
CONSTRAINT  "check_active" CHECK (
active >=0
)
);

MySQL meldet: Dokumentation

#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 '"users" (
    "id" SERIAL NOT NULL,
    "ip_address" inet NOT NULL,
    "usernam' at line 1

Arrow768 · 07-26-2013 , 12:37 Re: Store WebPanel

Quote:

Originally Posted by justicex333

can some body help me?

1.

PHP Code:


			
[...]

2-

PHP Code:


			
[...]

Would you mind telling us what you have done when you had the problem ?

htcarnage · 07-26-2013 , 14:16 Re: Store WebPanel

Advice to fix the error im seeing? (2 or so posts up) Its stopping me using the plugin entirely

justicex333 · 07-26-2013 , 14:26 Re: Store WebPanel

how can i fix

#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 '"users" (
"id" SERIAL NOT NULL,
"ip_address" inet NOT NULL,
"usernam' at line 1

this?

Arrow768 · 07-26-2013 , 16:10 Re: Store WebPanel

Quote:

Originally Posted by htcarnage

Advice to fix the error im seeing? (2 or so posts up) Its stopping me using the plugin entirely

Start reading at page 15 at the last post

Gatherix · 07-26-2013 , 19:58 Webpanel Problems

EDIT: I have fixed the problem myself, it was due to the overly-complicated setup I have in place for the networking of my servers. Please disregard the original inquiry. Thanks anyways!

Code:

Hi there!

My apologies for posting such a petty problem here, but as too many people have already pointed out the SourceDonate site, and thus the corresponding issue system Jira, are currently unavailable.

I have followed the makeshift instructions precisely and have met all its conditions and criteria to my knowledge:


	Quote:
	
	
		
			
				
					Originally Posted by Arrow768
					
				
				You can download a Version of the Webpanel here

A very short installation guide:
* Upload all the files to your Webserver
* Edit the application/config/database.php to point to the store db (dont forget to remove the [])
* Enter a encryption key in the application/config/config.php
* Import the application/sql/ion_auth.sql into the store database
* Login to the webpanel with the default login details (user:[email protected] pass:password)
* Change the login details via the webpanel (NOT WITH PHPMYADMIN)
* Dont forget to update your webpanel to the latest version when the repo is online again

Some requirements:
A LAMP installation with php 5.4 (5.3 should work too) and enabled short open tags
			
		
	
	
Upon attempting to log in, I receive an "Incorrect Login" error, regardless of the username/password entered (including the default provided in the above guide, what I found in the appropriate database [which appears to be a random string of characters, however I have not changed it], et cetera). All appropriate software is updated and installed, and all databases/config files are, to my knowledge, correctly configured; I'm running on a VPS with PHP 5.3 and Apache 2. I'm sure I'm missing something simple as I've been working on similar stuff all day and it's enlarging my brain cavity, but I haven't been able to find any solution or previous reports of this error. I found what I thought to be an error in the programming of application/controllers/auth.php but have since confirmed the suspicion to be false after some tweaking (the original has been restored). I have not tried setting this up under a second server environment. Ideas?

Thanks!

WhoDatNation · 07-26-2013 , 20:20 Re: Store WebPanel

I am getting this error:

A Database Error Occurred

Unable to connect to your database server using the provided settings.
Filename: core/Loader.php
Line Number: 346

----------------------------------------------------------------------
Database.php
...
$db['default']['hostname'] = 'whodatgaming.clanservers.com';
$db['default']['username'] = 'c1056622_store';
$db['default']['password'] = 'c1056622_wdn';
$db['default']['database'] = '**********';
$db['default']['dbdriver'] = 'mysql';
...

Gatherix · 07-26-2013 , 20:46 Re: Store WebPanel

Quote:

Originally Posted by WhoDatNation

I am getting this error:

A Database Error Occurred

Unable to connect to your database server using the provided settings.
Filename: core/Loader.php
Line Number: 346

----------------------------------------------------------------------
Database.php
...
$db['default']['hostname'] = 'whodatgaming.clanservers.com';
$db['default']['username'] = 'c1056622_store';
$db['default']['password'] = 'c1056622_wdn';
$db['default']['database'] = '**********';
$db['default']['dbdriver'] = 'mysql';
...

The error is telling you that it can't connect to the database; ensure that database.php has been properly edited and uploaded, the format is correct in regards to the OS of your host, and that the login credentials completely match what's set in the database. Since you're using a domain, ensure your DNS records are setup correctly and properly account for the subdomain.

If none of that works, you may be able to bypass the error temporarily by setting $db['default']['db_debug'] to FALSE, though that's not a good long-term solution.