GBay - A Garry's Mod marketplace!

[XxLMM13xXx]

[QUOTE=MeLikeyCheese;52626357]GBay MySQL Error: Table 'parallax_gbay.serverinfo' doesn't exist.

I made a database called "parallax_gbay", so where it asked for the database in the config, I put "parallax_gbay"[/QUOTE]

Did you make sure the database is open to external connections?

[MeLikeyCheese]

How would I go about checking that on my cPanel?

[editline]29th August 2017[/editline]

[IMG]https://i.imgur.com/GPNYRiG.png[/IMG]

[XxLMM13xXx]

[QUOTE=MeLikeyCheese;52627132]How would I go about checking that on my cPanel?

[editline]29th August 2017[/editline]

[IMG]https://i.imgur.com/GPNYRiG.png[/IMG][/QUOTE]

Actually wipe the gbay database completely and restart your server I misread your error

[MeLikeyCheese]

[ERROR] addons/ulib/lua/ulib/shared/hook.lua:109: addons/gbay-1.1.5/lua/gbay/mysql/sv_mysql.lua:149: attempt to get length of field 'data' (a nil value)
1. fn - [C]:-1
2. unknown - addons/ulib/lua/ulib/shared/hook.lua:109

Ive wiped the database, added the database access back like last time. Same issue, except now I have this.

[XxLMM13xXx]

[QUOTE=MeLikeyCheese;52631161][ERROR] addons/ulib/lua/ulib/shared/hook.lua:109: addons/gbay-1.1.5/lua/gbay/mysql/sv_mysql.lua:149: attempt to get length of field 'data' (a nil value)
1. fn - [C]:-1
2. unknown - addons/ulib/lua/ulib/shared/hook.lua:109

Ive wiped the database, added the database access back like last time. Same issue, except now I have this.[/QUOTE]

Make sure you wiped the database not just cleared it... There should be no tables or ANYTHING!

[MeLikeyCheese]

I completely deleted it and made a new one. It's definitely cleared. Same error.

[Cards]

Wow, this is really cool. Can't wait to use it!

[MeLikeyCheese]

@XxLMM13xXx Anything else I can try?

[MeLikeyCheese]

Hello? If you give up trying to help me, just say. That way I can give up waiting for you to reply.

[Rako]

[QUOTE=MeLikeyCheese;52646359]Hello? If you give up trying to help me, just say. That way I can give up waiting for you to reply.[/QUOTE]

That's some serious passive-aggressive talking mate.

[MeLikeyCheese]

Well, its been 6 days since he last said anything, I have a server to run, but never mind. Il give up.

[XxLMM13xXx]

[QUOTE=MeLikeyCheese;52653343]Well, its been 6 days since he last said anything, I have a server to run, but never mind. Il give up.[/QUOTE]

In my free time I have been working on a gbay2 however that may not come out for a while i'm not sure about the problems you have been having. When I find free time I will look into it

[ZombiezPvP]

GBay MySQL Error: Table 'nuggetmi_gbay.bans' doesn't exist

[Jlx7]

[GBay] Connected to database...
[GBay] Currently stores...
addons/gbay/lua/gbay/mysql/sv_mysql.lua:149: attempt to get length of field 'data' (a nil value)

GBay MySQL Error: Table 'alexs7_gbay.serverinfo' doesn't exist
addons/gbay/lua/gbay/core/sv_core.lua:182: attempt to compare number with nil

GBay MySQL Error: Table 'alexs7_gbay.bans' doesn't exist
addons/gbay/lua/gbay/core/sv_core.lua:266: attempt to compare number with nil
how to fix this?
i type in console command reset mysql base and nothing did not happen.

[andreblue]

Tables are missing. Try deleting them thru the mysql

[Jlx7]

this is the problem, i open phpMyAdmin and watch sql base. all clear

[jonas9105]

Hey!

To fix the error that is something with .bans or something table missing.
You have to go to phpMyAdmin find the database and then go to SQL then you type in this:
CREATE TABLE IF NOT EXISTS `ads` (
  `id` int(11) NOT NULL,
  `asid` varchar(17) NOT NULL,
  `type` varchar(255) NOT NULL,
  `iid` int(255) NOT NULL,
  `timetoexpire` int(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `bans` (
  `id` int(11) NOT NULL,
  `bid` varchar(17) NOT NULL,
  `aid` varchar(17) NOT NULL,
  `time` int(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `entities` (
  `id` int(11) NOT NULL,
  `sidmerchant` varchar(17) NOT NULL,
  `name` varchar(27) NOT NULL,
  `description` varchar(81) NOT NULL,
  `ent` varchar(255) NOT NULL,
  `price` int(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `orders` (
  `id` int(11) NOT NULL,
  `sidmerchant` varchar(17) NOT NULL,
  `sidcustomer` varchar(17) NOT NULL,
  `type` varchar(255) NOT NULL,
  `weapon` varchar(255) NOT NULL,
  `weaponshipname` varchar(255) NOT NULL,
  `quantity` int(255) NOT NULL,
  `pricepaid` int(255) NOT NULL,
  `timestamp` int(255) NOT NULL,
  `completed` tinyint(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `players` (
  `id` int(11) NOT NULL,
  `sid` varchar(17) NOT NULL,
  `rank` varchar(255) NOT NULL,
  `positiverep` int(255) NOT NULL,
  `neutralrep` int(255) NOT NULL,
  `negativerep` int(255) NOT NULL,
  `rating` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `serverinfo` (
  `id` int(11) NOT NULL,
  `servername` varchar(15) NOT NULL,
  `ads` tinyint(1) NOT NULL,
  `services` tinyint(1) NOT NULL,
  `coupons` tinyint(1) NOT NULL,
  `feepost` int(255) NOT NULL,
  `maxprice` int(255) NOT NULL,
  `taxpercent` int(255) NOT NULL,
  `ttnoo` int(255) NOT NULL,
  `npcpos` varchar(255) NOT NULL,
  `npcang` varchar(255) NOT NULL,
  `npcmodel` varchar(255) NOT NULL,
  `ranks` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `service` (
  `id` int(11) NOT NULL,
  `sidmerchant` varchar(17) NOT NULL,
  `name` varchar(20) NOT NULL,
  `description` varchar(81) NOT NULL,
  `price` int(255) NOT NULL,
  `buyers` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `shipments` (
  `id` int(11) NOT NULL,
  `sidmerchant` varchar(17) NOT NULL,
  `name` varchar(27) NOT NULL,
  `description` varchar(81) NOT NULL,
  `wep` varchar(255) NOT NULL,
  `wepname` varchar(255) NOT NULL,
  `price` int(255) NOT NULL,
  `amount` int(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTER TABLE `ads`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `bans`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `entities`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `players`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `serverinfo`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `service`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `shipments`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `ads`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `bans`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `entities`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `orders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `players`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `serverinfo`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `service`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `shipments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
And then you press submit or whatever the button is.
Try !gbay again (no restart required) and there you go :-)

If it fixed it please give me a thanks :-)

[Jlx7]

Thanks for this fix.
pity that coder not update the addon

[jonas9105]

You cant delete mysql tables if they are missing.