Database Error - Error in query (1046): No database selected


#1

Can somebody help me how to upload this DB or what changes needs to be done. i m getting this error. Error in query (1046): No database selected

(upload://2lx5ltDBLWtTlq6joD8eFgXjpjU.png)


#2

Hello @claadssclassifieds,

Where are you uploading this DB? And from where? Please provide further information so I can have a look. Also, upload the reference image again.

Regards,
Ibad Rehman
Community Manager


#3

CREATE ALGORITHM=UNDEFINED DEFINER=root@localhost SQL SECURITY DEFINER VIEW tbl_roznamcha_view AS select x.id AS id,x.name AS name,date_format(x.cur_date,’%M %e, %Y’) AS cur_date,x.auto_date_time AS auto_date_time,x.description AS description,x.currency AS currency,x.rate AS rate,x.debit AS debit,x.credit AS credit,sum(y.bal) AS tBalance from (((select tbl_roznamcha.id AS id,tbl_roznamcha.cur_date AS cur_date,tbl_roznamcha.auto_date_time AS auto_date_time,tbl_roznamcha.name AS name,tbl_roznamcha.description AS description,tbl_roznamcha.currency AS currency,tbl_roznamcha.rate AS rate,tbl_roznamcha.debit AS debit,tbl_roznamcha.credit AS credit,(-(tbl_roznamcha.debit) + tbl_roznamcha.credit) AS bal from tbl_roznamcha)) X join (select tbl_roznamcha.id AS id,tbl_roznamcha.cur_date AS cur_date,tbl_roznamcha.auto_date_time AS auto_date_time,…
Error in query (1349): View’s SELECT contains a subquery in the FROM clause