error #1548

Status
Not open for further replies.

leafypiggy

Manager of Pens and Office Supplies
Staff member
Messages
3,819
Reaction score
163
Points
63
The table is not corrupt. As I have asked you several times before, what is the procedure you are trying to run? I need the SQL query.
 

cbtis18x

Member
Messages
30
Reaction score
0
Points
6
DELIMITER $$
--
-- Procedimientos
--
CREATE DEFINER=`cbtis18`@`localhost` PROCEDURE `acceso`(in loginusu varchar(45),in passwd varchar(15),out res varchar(250))
begin
if(select count(*) from usuarios where nom_usu=loginusu and pwd_usu=passwd)=0 then
set res="Error login o password incorrectos";
else
set res="Bienvenido";
end if;
end$$




please help
 

ChatIndia

Community Advocate
Community Support
Messages
1,408
Reaction score
30
Points
48
Hi, if you believe that the problem can only be resolved from the command line then you can install latest version of 'xampp' on your local computer and then import the database to your locally hosted database server, repair it there and then import it back to your server. That will be the simplest solution that I see.
 

cbtis18x

Member
Messages
30
Reaction score
0
Points
6
the problem is with the table of procedures on the server as it will not run or consulting me and I have no privileges to repair the table procs
 

cbtis18x

Member
Messages
30
Reaction score
0
Points
6
someone who can help me ???

Someone who has sufficient permissions to use the command table repair routines
 

brittbr2

Member
Messages
99
Reaction score
11
Points
8
Please stop spamming the community they are trying to help but your spam is moving it hard for them
 

cbtis18x

Member
Messages
30
Reaction score
0
Points
6
the truth is that I have a lot with this problem and do not help me is not spam
 
Status
Not open for further replies.
Top