[damiancipolat]

Help!!
i can't create a stored procedure in phpmyadmin in 000webhost.

i'm using a free count.

someone could create a sp?

example:
delimiter //
create procedure hi()
begin
select 'hola';

end

error msg:
#1547 - Column count of mysql.proc is wrong. Expected 20, found 16. The table is probably corrupted

[Leder678]

could you show us the exact code, from line 1500-1600 ?

[damiancipolat]

All the code is it:

delimiter //
CREATE PROCEDURE hi( )
BEGIN
SELECT 'hola';
END

(and in phpmyadmin delimiter field //)


MySQL said:

#1547 - Column count of mysql.proc is wrong. Expected 20, found 16. The table is probably corrupted

I think in a problem with the mysql of the database in 000webhost..this code function very well in other mysql from other web.

About the bug:
http://bugs.mysql.com/bug.php?id=56242

[grace1004]

It looks like phpmyadmin in 000webhost.com does not support a stored procedure.

After testing at the phpmyadmin installed in my PC, I found that creating a stored
procedure(SP) is possible, but calling SP with a select query was not working.
SP with an insert query worked. That is, my phpmyadmin also does not fully support
the stored procedure. When I tested the same SP's at MySQL console screen, it worked
fine.

If you still want to use SP, just save frequently used queries in text file, copy
and paste it on query box whenever needed.

[damiancipolat]

yes don't function in 000webhost.!,there use a phpmyadmin oldversion,the newest version is great! http://demo.phpmyadmin.net/master-config/ the sp function ok! and have a cool User interface!

thank's for reply.
grettings

[Ural]

Hi there,
so the solution is that stored procedures cannot be used on 000webhost and that's it?

Is there another way to create a stored procedure (maybe a different SQL editor than phpMyAdmin) or something else?

What if we need stored procs in our database?

How did you fix the problem?

Thanks a million,
Gianluca