ERROR 1146 (42S02): Table 'xtream_iptvpro.reg_users' doesn't exist

[mcniptv]

Hello ALL i made a Fresh installation of Xtream UI follows all step and in final the login default doesnt work admin/admin, i tried to change but gave me this error in putty

ERROR 1146 (42S02): Table 'xtream_iptvpro.reg_users' doesn't exist
what should i do ! Thanks

 

[mcniptv]

i tried but now work ! any other solution !

 

[satstyler]

Try the following;

using SSH:

mysql -pPASSWORD

Now type:

UPDATE xtream_iptvpro.reg_users SET password='$6$rounds=20000$xtreamcodes$XThC5OwfuS0YwS4ahiifzF14vkGbGsFF1w7ETL4sRRC5sOrAWCjWvQJDromZUQoQuwbAXAFdX3h3Cp3vqulpS0' WHERE id='1';
UPDATE xtream_iptvpro.reg_users SET username = 'admin' WHERE id = '1';
UPDATE xtream_iptvpro.reg_users SET member_group_id = '1' WHERE id = '1';

Login using admin/admin

The above should reset the password

 

[mcniptv]

when i type in ssh
mysql -pPASSWORD


mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

 

[guetteur]

If: Table 'xtream_iptvpro.reg_users' doesn't exist
you need to reinstall first the MAIN server and after ADMIN
cheers.

 

[redhat]

Hello ALL i made a Fresh installation of Xtream UI follows all step and in final the login default doesnt work admin/admin, i tried to change but gave me this error in putty

ERROR 1146 (42S02): Table 'xtream_iptvpro.reg_users' doesn't exist
what should i do ! Thanks

reinstall the Server with fresh ubuntu 18.04 and retry the installation

 

[mcniptv]

i will try thanks for help so much !

 

[mcniptv]

reinstall the Server with fresh ubuntu 18.04 and retry the installation

Same i reinstalled fresh and follow all steps when i want to login with default i got

Incorrect username or password! Please try again.

 

[malaquias]

lol the error was because
table reg_users doesnt exists
you need to login via phpmyadmin example
and in database: xtream_iptvpro
Create a table with name: reg_users

 

[mcniptv]

lol the error was because
table reg_users doesnt exists
you need to login via phpmyadmin example
and in database: xtream_iptvpro
Create a table with name: reg_users

can you give me more information about phpmyadmin

 

[malaquias]

can you give me more information about phpmyadmin

apt-get install phpmyadmin
select apache2 auto config
open http://yourip/phpmyadmin
login with proper mysql username and password
if you can't login with root , make login with iptv_pro_xtream created user with the password given in xtream-ui setup at the end,

 

[mcniptv]

apt-get install phpmyadmin
select apache2 auto config
open http://yourip/phpmyadmin
login with proper mysql username and password
if you can't login with root , make login with iptv_pro_xtream created user with the password given in xtream-ui setup at the end,

Fix it thabk you so much

 

[Extra]

apt-get install phpmyadmin
select apache2 auto config
open http://yourip/phpmyadmin
login with proper mysql username and password
if you can't login with root , make login with iptv_pro_xtream created user with the password given in xtream-ui setup at the end,

I got the same issue, tho after installed phpmyadmin and trying to access it at http://myip/phpmyadmin it gives me 404 error, "The requested URL was not found on this server. " Any tips would be appreciated!

 

[reaper9640]

It's because phpmyadmin isn't installed mate as part of the install

 

[reaper9640]

They adding database.php after your dns and port

 

[Extra]

Thanks for the reply mate, Hmm, I have installed phpmyadmin as Malaquias guide over here. Its after that, when I try to access it, it gives me 404 error. Or is it something I dont understand?

 

[reaper9640]

I'm not sure mate I just done the genuine release for one of my friends and they have had no issues at all

 

[Extra]

Ok, no worries. I have had several reinstallations now, all with same errors....

 

[reaper9640]

I wish I could help you mate but I don't even really know anything about the panel itself I just followed the install script for them and it apparently works for them I couldn't tell you anything beyond that I'm afraid

 

[chris]

you need create table xtream_iptvpro.reg_users' in mysql