kentlucky's Profile User Rating: -----

Reputation: 4 Apprentice
Group:
Active Members
Active Posts:
84 (0.07 per day)
Joined:
20-June 12
Profile Views:
1,614
Last Active:
User is offline Aug 06 2015 01:42 AM
Currently:
Offline

Previous Fields

Dream Kudos:
0
Icon   kentlucky has not set their status

Posts I've Made

  1. In Topic: Need help in my new Web Hosting Provider

    Posted 5 Aug 2015

    View Postmodi123_1, on 06 August 2015 - 12:03 PM, said:

    Talk to your hosting.


    Hello Sir,

    Thanks for your help. I am now sure that this is on the hosting provider side.

    Thanks a lot!

    Kent
  2. In Topic: Need help in my new Web Hosting Provider

    Posted 5 Aug 2015

    View Postmodi123_1, on 06 August 2015 - 11:26 AM, said:

    Does your user ID have access and permissions on all those tables?

    GRANT CREATE VIEW ON *.* TO '<username>'@'<host>'; 
    


    Barring that contact your ISP and make sure you have permissions to create views.


    Hi Sir,

    I am not really sure if my user id has access and permissions on all tables so I try to run this sql code
    GRANT CREATE VIEW ON *.* TO 'hradmin'@'localhost';
    


    but i get this error
    #1045 - Access denied for user 'hradmin'@'%' (using password: YES)
    


    Thanks
  3. In Topic: Need help in my new Web Hosting Provider

    Posted 5 Aug 2015

    Hello Sir,

    I now removed the ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER and this is now my sql command:
    CREATE VIEW `jobslist_view` AS select `a`.`job_id` AS `job_id`,`a`.`position` AS `position`,`a`.`description` AS `description`,`a`.`date_posted` AS `date_posted`,`a`.`date_inactive` AS `date_inactive`,`a`.`number_of_vacancy` AS `number_of_vacancy`,`b`.`hospital_id` AS `hospital_id`,`b`.`hospital_name` AS `hospital_name`,`b`.`hospital_address` AS `hospital_address`,`b`.`hospital_phone` AS `hospital_phone`,`b`.`hospital_email` AS `hospital_email`,`c`.`realname` AS `realname`,`c`.`user_id` AS `user_id` from ((`jobs_tbl` `a` left join `hospitals_tbl` `b` on((`a`.`hospital_id` = `b`.`hospital_id`))) left join `users_tbl` `c` on((`a`.`user_id` = `c`.`user_id`))) where (`a`.`archive` = 0)
    


    But i got this error message

    #1142 - CREATE VIEW command denied to user 'hradmin'@'localhost' for table 'jobslist_view'
    


    Thank you so much for your patience.
  4. In Topic: Need help in my new Web Hosting Provider

    Posted 5 Aug 2015

    View Postmodi123_1, on 06 August 2015 - 10:55 AM, said:

    I am confused by your 'create view'. Why is there this whole 'create algorithm' bit?

    CREATE VIEW <view name> AS <select statement>
    


    Well. .wait a minute.. I am not sure what's going on in those bottom pictures..

    Can you run the select statement by itself.. sans 'create view'



    Hello Sir,

    thank you so much for your fast response.

    On my Local computer, I create the "Create View" command using the phpmyadmin. you can also see it on the save2 image attachment. When i export the sql database, i open the file which hrjobs.sql and this sql is generated:
    CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `jobslist_view` AS select `a`.`job_id` AS `job_id`,`a`.`position` AS `position`,`a`.`description` AS `description`,`a`.`date_posted` AS `date_posted`,`a`.`date_inactive` AS `date_inactive`,`a`.`number_of_vacancy` AS `number_of_vacancy`,`b`.`hospital_id` AS `hospital_id`,`b`.`hospital_name` AS `hospital_name`,`b`.`hospital_address` AS `hospital_address`,`b`.`hospital_phone` AS `hospital_phone`,`b`.`hospital_email` AS `hospital_email`,`c`.`realname` AS `realname`,`c`.`user_id` AS `user_id` from ((`jobs_tbl` `a` left join `hospitals_tbl` `b` on((`a`.`hospital_id` = `b`.`hospital_id`))) left join `users_tbl` `c` on((`a`.`user_id` = `c`.`user_id`))) where (`a`.`archive` = 0);
    


    I try to do the same thing on the web hosting but i've got an error access denied.

    I'm sorry if my explanation is not understandable but I will try my best to explain it.

    Thank you so much.
  5. In Topic: Please check my site

    Posted 7 May 2015

    View Postprasanthquadra, on 06 May 2015 - 09:16 PM, said:

    Hi,your website is responsive are superb one suggestion responsive scroll in page the menu only fixed in scroll or create an go to top button,
    website is perfect in responsives.web site top corner left this simple(-->)kindly remove it.


    Hi Thanks for the good review. I remove the --> already. thank you :)

My Information

Member Title:
D.I.C Head
Age:
Age Unknown
Birthday:
Birthday Unknown
Gender:

Contact Information

E-mail:
Private

Friends

Comments

kentlucky has no profile comments yet. Why not say hello?