Веб [WebMCR] Модули и дополнения (9 шт.)

[The_Luuzzi]

Администрирование, сайт, дополнительно.

 

[serega6531]

Не назначили id предмета.

SQLError: [SELECT * FROM `shop_categories` WHERE id='0']

 

[The_Luuzzi]

Не назначили id предмета.

проблема была не поставил плагин ShoppingCart-1.5.3

Не назначили id предмета.

Ну все равно лайк)

 

[Toster_tpl]

@Toster_tpl, а майлбокс я так понимаю платным будет?

Нет. Целиком и полностью бесплатным.

 

[Vadko]

Нет. Целиком и полностью бесплатным.

А когда форум будет?

 

[The_Luuzzi]

ShoppingCart-1.5.3 не работает на ведре 1.5.2

 

[Repack]

ShoppingCart-1.5.3 не работает на ведре 1.5.2

Все работает.

 

[The_Luuzzi]

Все работает.

У меня ошибку дает..

 

[Toster_tpl]

А когда форум будет?

Когда руки дойдут

У меня ошибку дает..

Ошибку в студию

 

[The_Luuzzi]

Когда руки дойдут

Ошибку в студию

23:32:18 [SEVERE] [ShoppingCart] Couldn't connect to database
java.sql.SQLException: invalid database address: mysql://s37.webhost1.ru
at org.sqlite.JDBC.createConnection(JDBC.java:74)
at org.sqlite.JDBC.connect(JDBC.java:64)
at java.sql.DriverManager.getConnection(DriverManager.java:579)
at java.sql.DriverManager.getConnection(DriverManager.java:221)
at net.rubukkit.limito.shoppingcart.service.DatabaseConnection.init(DatabaseConnection.java:42)
at net.rubukkit.limito.shoppingcart.ShoppingCartPlugin.initDBConnection(ShoppingCartPlugin.java:166)
at net.rubukkit.limito.shoppingcart.ShoppingCartPlugin.onEnable(ShoppingCartPlugin.java:56)
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:217)
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:457)
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:381)
at org.bukkit.craftbukkit.v1_5_R3.CraftServer.loadPlugin(CraftServer.java:282)
at org.bukkit.craftbukkit.v1_5_R3.CraftServer.enablePlugins(CraftServer.java:264)
at net.minecraft.server.v1_5_R3.MinecraftServer.j(MinecraftServer.java:304)
at net.minecraft.server.v1_5_R3.MinecraftServer.e(MinecraftServer.java:283)
at net.minecraft.server.v1_5_R3.MinecraftServer.a(MinecraftServer.java:243)
at net.minecraft.server.v1_5_R3.DedicatedServer.init(DedicatedServer.java:151)
at net.minecraft.server.v1_5_R3.MinecraftServer.run(MinecraftServer.java:382)
at net.minecraft.server.v1_5_R3.ThreadServerApplication.run(SourceFile:573)

 

[Repack]

23:32:18 [SEVERE] [ShoppingCart] Couldn't connect to database
java.sql.SQLException: invalid database address: mysql://s37.webhost1.ru

Сразу ничего на ум не приходит?

 

[Toster_tpl]

Couldn't connect to database. Проверьте верно ли введены данные базы в конфиге плагина.

 

[Repack]

Вот как должен выглядеть конфиг http://prntscr.com/1b0d6a

 

[The_Luuzzi]

Сразу ничего на ум не приходит?

23:39:04 [SEVERE] [ShoppingCart] Couldn't connect to database
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'luuzzi_lk'@'%' to database 'shopcart'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.Util.getInstance(Util.java:382)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:931)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4031)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
at java.sql.DriverManager.getConnection(DriverManager.java:579)
at java.sql.DriverManager.getConnection(DriverManager.java:221)
at net.rubukkit.limito.shoppingcart.service.DatabaseConnection.init(DatabaseConnection.java:42)
at net.rubukkit.limito.shoppingcart.ShoppingCartPlugin.initDBConnection(ShoppingCartPlugin.java:167)
at net.rubukkit.limito.shoppingcart.ShoppingCartPlugin.onEnable(ShoppingCartPlugin.java:57)
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:217)
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:457)
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:381)
at org.bukkit.craftbukkit.v1_5_R3.CraftServer.loadPlugin(CraftServer.java:282)
at org.bukkit.craftbukkit.v1_5_R3.CraftServer.enablePlugins(CraftServer.java:264)
at net.minecraft.server.v1_5_R3.MinecraftServer.j(MinecraftServer.java:304)
at net.minecraft.server.v1_5_R3.MinecraftServer.e(MinecraftServer.java:283)
at net.minecraft.server.v1_5_R3.MinecraftServer.a(MinecraftServer.java:243)
at net.minecraft.server.v1_5_R3.DedicatedServer.init(DedicatedServer.java:151)
at net.minecraft.server.v1_5_R3.MinecraftServer.run(MinecraftServer.java:382)
at net.minecraft.server.v1_5_R3.ThreadServerApplication.run(SourceFile:573)
и?

jdbc:mysql://s37.webhost1.ru/shopcart вот так терь ввел
23:41:11 [SEVERE] [ShoppingCart] Couldn't connect to database
java.sql.SQLException: invalid database address: mysql://s37.webhost1.ru/shopcart
at org.sqlite.JDBC.createConnection(JDBC.java:74)
at org.sqlite.JDBC.connect(JDBC.java:64)
at java.sql.DriverManager.getConnection(DriverManager.java:579)
at java.sql.DriverManager.getConnection(DriverManager.java:221)
at net.rubukkit.limito.shoppingcart.service.DatabaseConnection.init(DatabaseConnection.java:42)
at net.rubukkit.limito.shoppingcart.ShoppingCartPlugin.initDBConnection(ShoppingCartPlugin.java:167)
at net.rubukkit.limito.shoppingcart.ShoppingCartPlugin.onEnable(ShoppingCartPlugin.java:57)
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:217)
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:457)
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:381)
at org.bukkit.craftbukkit.v1_5_R3.CraftServer.loadPlugin(CraftServer.java:282)
at org.bukkit.craftbukkit.v1_5_R3.CraftServer.enablePlugins(CraftServer.java:264)
at net.minecraft.server.v1_5_R3.MinecraftServer.j(MinecraftServer.java:304)
at net.minecraft.server.v1_5_R3.MinecraftServer.e(MinecraftServer.java:283)
at net.minecraft.server.v1_5_R3.MinecraftServer.a(MinecraftServer.java:243)
at net.minecraft.server.v1_5_R3.DedicatedServer.init(DedicatedServer.java:151)
at net.minecraft.server.v1_5_R3.MinecraftServer.run(MinecraftServer.java:382)
at net.minecraft.server.v1_5_R3.ThreadServerApplication.run(SourceFile:573)
и так вводил mysql://s37.webhost1.ru/shopcart

 

[Repack]

Название бд должно быть после слеша.
table: название таблицы, в нашем случае это shop_cart
И если не будет подключения, поставь галочку удаленного доступа в биллинге.

 

[The_Luuzzi]

удаленное подключение стоит,у меня на машине стоит java6 это играет роль?Какой должна быть приставка? jdbc:mysql://?mysql://?

 

[Repack]

db:
url: jdbc:mysql://самхост:порт/название бд
username: ник
password: пароль
table: shop_cart

 

[Vadko]

23:39:04 [SEVERE] [ShoppingCart] Couldn't connect to database
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'luuzzi_lk'@'%' to database 'shopcart'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.Util.getInstance(Util.java:382)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:931)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4031)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
at java.sql.DriverManager.getConnection(DriverManager.java:579)
at java.sql.DriverManager.getConnection(DriverManager.java:221)
at net.rubukkit.limito.shoppingcart.service.DatabaseConnection.init(DatabaseConnection.java:42)
at net.rubukkit.limito.shoppingcart.ShoppingCartPlugin.initDBConnection(ShoppingCartPlugin.java:167)
at net.rubukkit.limito.shoppingcart.ShoppingCartPlugin.onEnable(ShoppingCartPlugin.java:57)
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:217)
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:457)
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:381)
at org.bukkit.craftbukkit.v1_5_R3.CraftServer.loadPlugin(CraftServer.java:282)
at org.bukkit.craftbukkit.v1_5_R3.CraftServer.enablePlugins(CraftServer.java:264)
at net.minecraft.server.v1_5_R3.MinecraftServer.j(MinecraftServer.java:304)
at net.minecraft.server.v1_5_R3.MinecraftServer.e(MinecraftServer.java:283)
at net.minecraft.server.v1_5_R3.MinecraftServer.a(MinecraftServer.java:243)
at net.minecraft.server.v1_5_R3.DedicatedServer.init(DedicatedServer.java:151)
at net.minecraft.server.v1_5_R3.MinecraftServer.run(MinecraftServer.java:382)
at net.minecraft.server.v1_5_R3.ThreadServerApplication.run(SourceFile:573)
и?

jdbc:mysql://s37.webhost1.ru/shopcart вот так терь ввел
23:41:11 [SEVERE] [ShoppingCart] Couldn't connect to database
java.sql.SQLException: invalid database address: mysql://s37.webhost1.ru/shopcart
at org.sqlite.JDBC.createConnection(JDBC.java:74)
at org.sqlite.JDBC.connect(JDBC.java:64)
at java.sql.DriverManager.getConnection(DriverManager.java:579)
at java.sql.DriverManager.getConnection(DriverManager.java:221)
at net.rubukkit.limito.shoppingcart.service.DatabaseConnection.init(DatabaseConnection.java:42)
at net.rubukkit.limito.shoppingcart.ShoppingCartPlugin.initDBConnection(ShoppingCartPlugin.java:167)
at net.rubukkit.limito.shoppingcart.ShoppingCartPlugin.onEnable(ShoppingCartPlugin.java:57)
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:217)
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:457)
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:381)
at org.bukkit.craftbukkit.v1_5_R3.CraftServer.loadPlugin(CraftServer.java:282)
at org.bukkit.craftbukkit.v1_5_R3.CraftServer.enablePlugins(CraftServer.java:264)
at net.minecraft.server.v1_5_R3.MinecraftServer.j(MinecraftServer.java:304)
at net.minecraft.server.v1_5_R3.MinecraftServer.e(MinecraftServer.java:283)
at net.minecraft.server.v1_5_R3.MinecraftServer.a(MinecraftServer.java:243)
at net.minecraft.server.v1_5_R3.DedicatedServer.init(DedicatedServer.java:151)
at net.minecraft.server.v1_5_R3.MinecraftServer.run(MinecraftServer.java:382)
at net.minecraft.server.v1_5_R3.ThreadServerApplication.run(SourceFile:573)
и так вводил mysql://s37.webhost1.ru/shopcart

возможно запрещено внешнее подключение к бд

 

[Toster_tpl]

Используйте тег спойлер для таких больших сообщений.
invalid database address: mysql://s37.webhost1.ru/shopcart
Говорит, что неверное название базы. База должна быть от вебмцр, а таблица shop_cart

 

[The_Luuzzi]

db:
url: jdbc:mysql://s37.webhost1.ru:3306/shop_cart
username: luuzzi_lk
password: пасс
table: shop_cart
column:
id: id
player: username
type: type
item: iid
amount: amount
extra: extra

Да webmcr стоит на этой же бд.
Лог

возможно запрещено внешнее подключение к бд

разрешено.