PDA

View Full Version : MuSite Erro 'Code'



MuSoul
06/07/2018, 02:09 PM
​Alguem Sabe Oque Pode Ser ?

Warning: mssql_query() [function.mssql-query ([Only registered and activated users can see links])]: message: Invalid column name 'code'. (severity 16) in C:\inetpub\vhosts\meusite.com\[Only registered and activated users can see links] \classes\ldmssql.class.php on line 48

Warning: mssql_query() [function.mssql-query ([Only registered and activated users can see links])]: Query failed in C:\inetpub\vhosts\meusite.com\[Only registered and activated users can see links] \classes\ldmssql.class.php on line 48
LD_Error: Não foi possivel executar: SELECT TOP 10 * FROM dbo.webNotices WHERE code=1 ORDER BY date DESC
Warning: mssql_fetch_object(): supplied argument is not a valid MS SQL-result resource in C:\inetpub\vhosts\meusite.com\[Only registered and activated users can see links] \classes\ldhome.class.php on line 42

russo1
06/07/2018, 06:31 PM
roda essa query



ALTER TABLE dbo.webNotices ADD code int NOT NULL DEFAULT 0
GO


se seu site for instalado na DB MuOnline, selecione para rodar na MuOnline
se seu site for instalado na DB webSite, selecione para rodar na webSite
...

MuSoul
06/07/2018, 07:41 PM
russo obrigado o outro erro que eu tenho e a parte que mostra os adms e gms
Warning: mssql_query() [FUNCTION.MSSQL-QUERY ([Only registered and activated users can see links])]: message: Invalid object name 'character'. (severity 16) in C:\inetpub\vhosts\muonline.com\[Only registered and activated users can see links] s\classes\ldtpl.class.php(76) : eval()'d code on line 152

Warning: mssql_query() [FUNCTION.MSSQL-QUERY ([Only registered and activated users can see links])]: Query failed in C:\inetpub\vhosts\muonline.com\[Only registered and activated users can see links] s\classes\ldtpl.class.php(76) : eval()'d code on line 152

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\inetpub\vhosts\muonline.com\[Only registered and activated users can see links] s\classes\ldtpl.class.php(76) : eval()'d code on line 153

Arcade
07/07/2018, 12:35 PM
russo obrigado o outro erro que eu tenho e a parte que mostra os adms e gms
Warning: mssql_query() [FUNCTION.MSSQL-QUERY ([Only registered and activated users can see links])]: message: Invalid object name 'character'. (severity 16) in C:\inetpub\vhosts\muonline.com\[Only registered and activated users can see links] s\classes\ldtpl.class.php(76) : eval()'d code on line 152

Warning: mssql_query() [FUNCTION.MSSQL-QUERY ([Only registered and activated users can see links])]: Query failed in C:\inetpub\vhosts\muonline.com\[Only registered and activated users can see links] s\classes\ldtpl.class.php(76) : eval()'d code on line 152

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\inetpub\vhosts\muonline.com\[Only registered and activated users can see links] s\classes\ldtpl.class.php(76) : eval()'d code on line 153

Esses erros acontecem porque o site não está encontrando a database do próprio site. Como você instalou as querys do Daldegan? Criou e instalou na database webSite??? Se sim, altere no settings o seguinte:



define('DATABASE', 'webSite'); //Banco de dados do website


Caso a instalação das tabelas do site foi em MuOnline então faça:



define('DATABASE', 'MuOnline'); //Banco de dados do website


Agora, caso nenhuma das 2 opções funcionar, rode os scripts do MuSite, que normalmente se encontram na pasta Modules.