Get a Freelance Job

Urgent MYSQL error to fix on a php site.
Looking for reviewed user and available right now
thanks.

Hi,

I need help fixing some mySQL errors… The page was working perfectly a while ago but just stopped and now its showing some errors.
(the page is a RSS reader)

Need this fixed now! (Should not be very complicated I hope) Please respect budget.

Thanks

Neighborhood website using Joomla and Jomsocial. Here is my error below that I need fixed. Thanks!

500 – DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘Articles) ORDER BY `created` DESC LIMIT ‘ at line 8 SQL=SELECT * FROM `jos_content` WHERE `created_by` = ’98′ AND `state`=’1′ AND `sectionid` IN (My Articles) ORDER BY `created` DESC LIMIT 0,10

I have a website here : http://bit.ly/ntiSBF After I tried to an upgrade the site broke down, so I restored files and database and no it returns me this error :Bad Subdomain SQL Query

Budget is $20. No escrow payment in full once delivered. NEED IT TODAY.

Need help fixing admin page for website. Keep getting Mysql error. Easy fix just out of my reach.

I have a links directory on my site that I used to be able to fill out a form and it would add a link to one of the pages in the directory. The site has moved server so its not setup anymore and shows an error.

So I need you to fix the error and find where the form is to fill out to add link automatically and make it all work again.

http://www.travelguide.tv/directory/memphis.html

I have a links directory on my site that I used to be able to fill out a form and it would add a link to one of the pages in the directory. The site has moved server so its not setup anymore and shows an error.

So I need you to fix the error and find where the form is to fill out to add link automatically and make it all work again.

http://www.travelguide.tv/directory/memphis.html

permissions were changed incorrectly?

see MySql error and fix

Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 7 in /home/relaxco/public_html/res/index.php on line 41

NEED mysql repair

A Mysql error has occurred while running the script:

The query you are trying to run is invalid
Mysql Error Output: Access denied for user ‘root’at localhost’ to database ‘sellit’
SQL Query: LOCK TABLE probid_auctions READ, probid_auctions AS a_update WRITE

A programmer is required to correct a database error on a joomla website. This needs to be done immediately and make site live.

In addition there is an error in the contact form that requires attention.

Today, for some reason, our site gets an error saying that Can’t connect to local MySQL server through socket ‘/var/tmp/mysql.sock’. Would like a quick fix for this.

Hello in the attached script we have a small error.
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /customers_copy.php on line 54

Can you solve this for us?

Need to solve/repair SQL error on script.
Im using Ventrino Traffic Exchange…

Problem is:
I setuped a min URL to surf -0 before account be active,
right now is 25 site to surf when testing – after 25 site come,
shows this error:

“Invalid query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE id=57976′ at line 1″

and this should not happend…

Alex

Site name: http://justautos.co.uk/
Error can be seen from: http://justautos.co.uk/index.php
We facing some myself database failure I need someone to fix it for us.
Once you have check and tell us this can be done we will accept your bid and provide you the mysql login details.

I have an error in a Joomla Site which is running Jomsocial. When I try to view a users profile, here is what is showing on the screen:

DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘submitted) ORDER BY `created` DESC LIMIT 0′ at line 11 SQL=SELECT a.*, b.permalink FROM `jos_content` AS a LEFT JOIN `jos_myblog_permalinks` AS b ON a.id = b.contentid WHERE `created_by` = ’63′ AND `state`=’1′ AND a.`sectionid` IN (user submitted) ORDER BY `created` DESC LIMIT 0,10

I need somebody who knows how to fix this first time and soon. Please don’t bid if you only think you can do it, I need a professional.

Many thanks,

J.

Hello,

I have a script, it displays all active banners using pagination. Once the banner is clicked it doesn’t show up again. This works fine.

The issue:

For example I’m displaying 25 banners per page, I have over 1000 active banners so there are 102 pages.

If I click on the all 25 of the banners on page one and then leave the site, the next time I come back to the site they do not show. This works correctly. But here is the problem, when I come back to the site page one is blank, I have to move on to page 2 in order to see the next round of banners. So in other words it’s not moving the banners up to page one.

I need this fixed.

Here is the code if you think you want to tackle it.

[code]
<?php

session_start();

include "../header.php";

include "../config.php";

include "../style.php";
$uname=$_SESSION[uname];
if( session_is_registered("ulogin") ) {

$tbl_name="banners"; //your table name

// How many adjacent pages should be shown on each side?

$adjacents = 3;

/*

First get total number of rows in data table.

If you have a WHERE clause in your query, make sure you mirror it here.

*/

if( session_is_registered("ulogin") )

{

$query = "SELECT COUNT(*) as num FROM banners, banner_clicks WHERE banners.status=1 and banners.max>banners.shown AND banner_clicks.userid<>'".userid."' group by banners.id";

}

else

$query = "SELECT COUNT(*) as num FROM $tbl_name WHERE status=1 and max>shown";

$ttlpag=mysql_query($query) or die (mysql_error());

$total_pages = mysql_fetch_array($ttlpag);

$total_pages = $total_pages[num];
$qn="select * from sat_banclicks where userid='$uname' group by bannerid";
$ns=mysql_query($qn);
$nk=mysql_num_rows($ns);
$total_pages=$total_pages-(2*$nk);
//echo $nk;

/* Setup vars for query. */

$targetpage = "bannerlinkview.php"; //your file name (the name of this file)

$limit = 25; //how many items to show per page

$page = $_GET['page'];

if($page)

$start = ($page - 1) * $limit; //first item to display on this page

else

$start = 1; //if no page var is given, set start to 0

/* Get data. */

if( session_is_registered("ulogin") )

{

$sql = "SELECT banners.id as id, banners.name as name, banners.bannerurl as bannerurl, banners.targeturl as targeturl, banners.userid as userid, banners.shown as shown, banners.clicks as clicks, banners.max as max, banners.added as added FROM banners, banner_clicks WHERE banners.status=1 and banners.max>banners.shown AND banner_clicks.userid<>'".userid."' group by banners.id LIMIT $start, $limit";

}

else

{

$sql = "SELECT * FROM banners WHERE status=1 and max>shown LIMIT $start, $limit";

}

$result = mysql_query($sql) or die (mysql_error());

if(!mysql_num_rows($result))

{

$result = mysql_query ("SELECT * FROM banners WHERE status=1 and max>shown LIMIT $start, $limit");

}

/* Setup page vars for display. */

if ($page == 0) $page = 1; //if no page var is given, default to 1.

$prev = $page - 1; //previous page is page - 1

$next = $page + 1; //next page is page + 1

$lastpage = ceil($total_pages/$limit); //lastpage is = total pages / items per page, rounded up.

$lpm1 = $lastpage - 1; //last page minus 1

/*

Now we apply our rules and draw the pagination object.

We're actually saving the code to a variable in case we want to draw it more than once.

*/

$pagination = "";

if($lastpage > 1)

{

$pagination .= "<div class="pagination">";

//previous button

if ($page > 1)

$pagination.= "<a href="$targetpage?page=$prev">